conn / as sysdba
oradebug setmypid
或者对其他session做跟踪
--连接到一个外部服务进程,且pid=v$process.pid
oradebug setorapid pid
--连接到一个外部服务进程,且spid=v$process.spid
oradebug setospid spid
oradebug event 10046 trace name context forever,level 12;
执行sql
set serveroutput on
declare
v_ret varchar(200);
begin
jyc.sp_findstring('lalala', 1, v_ret);
DBMS_OUTPUT.PUT_LINE('OUT_RETURN = "' || v_ret || '"');
end;
/
查看对应的trc文件及目录
oradebug tracefile_name;
oradebug event 10046 trace name context off;