DECLARE
L_ID NUMBER := 1;
L_STATUS VARCHAR2(200);
L_MESSAGE VARCHAR2(2000);
BEGIN
EXECUTE IMMEDIATE 'begin cux_xxx_pkg.xx(p_invoice_id => :1,
x_status => :2,
x_error_message => :3);
end;'
using in L_ID, out L_STATUS, out L_MESSAGE;
dbms_output.put_line(L_STATUS);
dbms_output.put_line(L_MESSAGE);
END;
动态sql调用存储过程
最新推荐文章于 2022-03-04 11:17:18 发布