ASA中执行动态sql的语句是什么?
bcboy 2001-12-17 08:40:17 我看了帮助,应该是 exectue immediate,但我在扫执行下面这个过程时却出错
drop procedure usp_test;
create procedure usp_test
as
begin
declare @sql varchar(255)
select @sql = "insert into c_option values ('v1',1,'test')"
execute immediate @sql
select * from c_option
end
在isql中执行 exec usp_test 出错,提示为:
Table or view not found: Procedure '@sql' not found
改为:
create procedure usp_test
as
begin
execute immediate "insert into c_option values ('v1',1,'test')"
select * from c_option
end
提示:Table or view not found: Procedure 'immediate' not found