sqlstr='create table tempdelete as select bs from tbparam where name='''||pname||''' '||and bs in (select bs from tbbase);execute immediate sqlstr;delete from tbbase where bs in (select bs from tempdelete);sqlstr='drop table tempdelete';execute immediate sqlstr;
阿涛是写在存储过程中的马。。? 怎么是MGR-00072: There is no more information about this error.lilygy5(我爱oracle) 的办法不是看到很懂。。Create table tbxxxxx as select .............这个直接执行可以,放到 存储过程中就不灵啦。。存储过程中联执行这样的语句都error? create or replace procedure testtest is begin select * from test2; end testtest;There is no more information about this error.
怎么是MGR-00072: There is no more information about this error.lilygy5(我爱oracle) 的办法不是看到很懂。。Create table tbxxxxx as select .............这个直接执行可以,放到
存储过程中就不灵啦。。存储过程中联执行这样的语句都error?
create or replace procedure testtest is
begin
select * from test2;
end testtest;There is no more information about this error.
先定义个字符串,比如SQLSTR,然后用下列语句
execute immediate SQLSTR只是连接字符串的时候注意字符串标记符号'的问题就可以了。
我试了是错误的阿
strstr varchar(200);
strstr:='select * from test';
错误了。