在存储过程里“execute immediate v_sql”与直接使用sql有什“execute immediate v_sql”与直接使用sql有什么区别?
execute immediate v_sql的例子:
begin
v_sql := 'select channel_id from imp_sh_cms_channel where wg_code =' ||
in_wg_id;
execute immediate v_sql
into v_contentid;
exception
when no_data_found then
out_result := 1; -- can't find data in imp_sh_cms_channel
rollback;
return;
end;
直接使用sql的例子:
begin
select channel_id into v_contentid from imp_sh_cms_channel where wg_code=in_wg_id;
exception
when no_data_found then
out_result := 1; -- can't find data in imp_sh_cms_channel
rollback;
return;
end;