oracle过程中如何让调用动态带参过程
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个参数,求大婶解答下,蟹蟹!