消息关闭
    暂无新消息!
 
SQL> var c varchar2(2000);
SQL> exec testdemo('{"aab078":"330301","aac001":"","aac002":"1","aac003":"q","aac004":"1","aac005":"01","aac006":"2017-07-18","aga001":"0002","bdc002":"","bsc412":"2"}',:c);
 
PL/SQL procedure successfully completed
c
---------
{
  "aab078" : "330301"
,
  "aac001" : ""
,
  "aac002" : "1"
,
  "aac003" : "q"
,
  "aac004" : "1"
,
  "aac005" : "01"
,
  "aac006" : "2017-07-18"
,
  "aga001" : "0002"
,
  "bdc002" : ""
,
  "bsc412" : "2"
,
  "pro_code" : "0"
,
  "pro_success" : false,
  "pro_msg" : "msg:\u4E0D\u80FD\u91CD\u590D\u4FDD\u5B58\u540C\u4E00\u4EBA\uFF01"

},我在命令行中可以执行,有返回结果C,放在过程里怎么写,应该怎么执行,testdemo中1个传入string ,一个传出string,一共2个参数,求大婶解答下,蟹蟹!

1个回答

︿ 0
exec testdemo 你这个就是过程里执行了啊。等价于
declare
c varchar2(2000):='dsdsad';
begin
testdemo(c);
end;