动态sql如下
declare rtndata nvarchar2(2000);mKeyID NUMBER;
begin
insert into t_vehicle_kind (id,code,name,org_id) values (S_vehicle_kind.NEXTVAL,'[email protected]','singletab','0') returning id into mKeyID;
rtndata:=rtndata||',{comp403:'||mKeyID||'}';
insert into t_vehicle_kind (id,code,name,org_id) values (S_vehicle_kind.NEXTVAL,'[email protected]','singletab','0') returning id into mKeyID;
rtndata:=rtndata||',{comp419:'||mKeyID||'}';
---- 怎么返回这个rtndata数据?
end;
也就是如何返回到这个上面,dsql就是上面的动态sql语句
EXECUTE IMMEDIATE dsql into r_data;
如何返回给r_data??
declare rtndata nvarchar2(2000);mKeyID NUMBER;
begin
insert into t_vehicle_kind (id,code,name,org_id) values (S_vehicle_kind.NEXTVAL,'[email protected]','singletab','0') returning id into mKeyID;
rtndata:=rtndata||',{comp403:'||mKeyID||'}';
insert into t_vehicle_kind (id,code,name,org_id) values (S_vehicle_kind.NEXTVAL,'[email protected]','singletab','0') returning id into mKeyID;
rtndata:=rtndata||',{comp419:'||mKeyID||'}';
---- 怎么返回这个rtndata数据?
end;
也就是如何返回到这个上面,dsql就是上面的动态sql语句
EXECUTE IMMEDIATE dsql into r_data;
如何返回给r_data??
也就是EXECUTE IMMEDIATE 里面执行后返回的字串在EXECUTE IMMEDIATE 这个层面取得额,不行就没法了