Oracle报告在OUT或IN-OUT上下文中使用的只读绑定变量 [英] Oracle Reports A READ-ONLY bind variable used in OUT or IN-OUT context

问题描述

如您在图像中看到的，我的报告中有一个公式列.编译时出现错误:在OUT或IN-OUT上下文中使用的只读绑定变量"

I have a formula column in my report as you can see in the image. When I compile it, I have an error: "A READ-ONLY bind variable used in OUT or IN-OUT context"

我的查询得到1行结果.图像中的属性.为什么会出现此错误，如何解决?

My query gets 1 line result. Properties like in the image. Why I got this error and what is the solution?

推荐答案

功能代码错误(显然，Oracle告诉过您).应该是这样的:

Function code is wrong (obviously; Oracle told you so). Should be something like this:

function CF_1Formula return char is
begin
  return case when :kart_geldimi = 'E' then 'sss'
              else null
         end;
end;

基本上，您创建了类似于循环引用的内容，并尝试将公式列用作OUT值(这是:cf_1 := 'sss';所做的事情).

Basically, you created something like a circular reference and tried to use formula column as the OUT value (that's what :cf_1 := 'sss'; did).

这篇关于Oracle报告在OUT或IN-OUT上下文中使用的只读绑定变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！