我的动态语句怎么才能运行?

2004-02-13 04:23:39 85 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Oracle中创建存储过程、运行动态SQL并得到动态SQL语句所查询的值 create or replace procedure proc_getnewfuhebyfacid(fac_id_s in varchar2,fac_id_e in varchar2,newfuhe_s out varchar2,newfuhe_e out varchar2) is tempaclnid varchar2(20); temp_s_aclndotid varchar2(20); t 阅读详情

问题行要怎么写才能运行?
我试过下面几种写法,都不行:

if exists (@str1)
if exists (exec @str1)
if exists (exec sp_executesql @str1)

declare @fisyear varchar(4)
declare @str1 varchar(300)
declare @t table (msg nvarchar(100))

set @fisyear='2003'

set @str1 = 'select distinct ts_office from cpm_timesheet where ts_fisyear='''+@fisyear+''' and ts_office not in (select distinct mf_office from cpm_MF where mf_fisyear='''+@fisyear+''')'
select @str1
if exists (@str1) <--问题行
begin
declare @err_mf cursor for @str1
open @err_mf
fetch next from @err_mf into @err_office
while @@fetch_status=0
begin
insert into @t values (@err_office+N'办公室 '+@fisyear+N'财政年度没有办公室倍率')
fetch next from @err_mf into @err_office
end
end
select * from @t

...全文