17,086
社区成员
发帖
与我相关
我的任务
分享执行一个动态语句的问题。
jin:='select n into liu from ddd where m=12';
execute immediate jin;
出错：
ora-00905:missing keyword
ora-06512:at line ??
execute immediate jin;
出错：
ora-00905:missing keyword
ora-06512:at line ??
...全文
请发表友善的回复…
发表回复
njhart2003 2005-07-21
- 打赏
- 举报
改成：
declare
liu varchar2(50);
l_m integer;
begin
...
jin:='select n from ddd where m=:v1';
execute immediate jin into liu using l_m;
....
declare
liu varchar2(50);
l_m integer;
begin
...
jin:='select n from ddd where m=:v1';
execute immediate jin into liu using l_m;
....
precipitant 2005-07-21
- 打赏
- 举报
明白了，原来是参数。谢谢
precipitant 2005-07-21
- 打赏
- 举报
declare
liu varchar2(50);
l_m integer;
begin
...
jin:='select n from ddd where m=:12';
execute immediate jin into liu;
....
这样可以了，但是你的那个l_m是干啥的。。。。。
