含自定义函数名的动态SQL语句问题.

[wu896222]

create or replace package body Test is
function fun1(id in varchar2) return varchar2
...
end;

procedure GetRecords(item in varchar2,cu_1 out mycursor)
sqlstr := "select fun1(aa) from test "
open cu_1
sqlstr;
end;
end;

如上,编译可以通过,但运行的时候会提示fun1非法定义.我试过,不用动态SQL
open cu_1
select fun1(aa) from test;
就是对的.

请教各位,如果一定要用动态SQL,怎么办?

[wu896222]

bzszp(SongZip),Thanks.

[bzszp]

test.fun1('aa')试试