首页 > 数据库 >oracle在SQL窗口中调用存储过程sql

oracle在SQL窗口中调用存储过程sql

时间:2022-09-28 14:59:45浏览次数:52  
标签:存储 rs sql json VARCHAR2 SQL oracle errmsg out

DECLARE
rs_json_out VARCHAR2(512);
p_errmsg VARCHAR2(512);
BEGIN
SP_SST_GET_CARD_NO('{"P_ZDBH00":"001","P_INSUORG":"360000","P_ID0000":"02","P_SFZHAO":"350821198608233016"}',rs_json_out,p_errmsg);
dbms_output.put_line('rs_json_out=' || rs_json_out);
dbms_output.put_line('p_errmsg=' || p_errmsg);
END;

备注:存储过程名称要大写

标签:存储,rs,sql,json,VARCHAR2,SQL,oracle,errmsg,out
From: https://www.cnblogs.com/yr1126/p/16738009.html

相关文章