在存储过程里这么用动态SQL,但是抛异常,请问怎么写这个功能的动态SQL
EXECUTE IMMEDIATE
'insert into te_bizfunction_filter_new(id,fun_id,corp_id,type)
select :id,t.id,:v_corp_id,t.type from te_bizfunction t where t.is_default=1'
USING fun_gid(),v_corp_id
EXECUTE IMMEDIATE
'insert into te_bizfunction_filter_new(id,fun_id,corp_id,type)
select :id,t.id,:v_corp_id,t.type from te_bizfunction t where t.is_default=1'
USING fun_gid(),v_corp_id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货