oracle 单引号 多重使用问题
原句
call p_aaa_call_proc(2123213,
'
aaa date aaa, aaa date aaa, aaa char ''2229'' aaa char ''LOCAL''
')
可以执行
sp_aaa('begin
p_aaa_call_proc(2123213,
'
aaa date aaa, aaa date aaa, aaa char ''2229'' aaa char ''LOCAL''
');
end;');
这样就执行失败, 求字符转义正确后的写法!
------解决方案--------------------
试试:
SQL code
sp_aaa('begin p_aaa_call_proc(2123213,''aaa date aaa, aaa date aaa, aaa char ''''2229'''' aaa char ''''LOCAL'''' '');end;''');