Hi ,
Were using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
I need to track a procedure to see which parameter value it's running with. It's run serveral times, each time a different procedure value ( which is a sequence id is passed to it as a parameter.
Is there a view or a DBA table I can use to get this info on a running process?
I've checked V$SESSIONS as well as ys.GV_$SQL_BIND_CAPTURE, ALL_STORED_SETTINGS, and ALL_PLSQL_OBJECT_SETTINGS and they're not giving me parameter values from a running procedure.
Does anyone know what I can use?
Again if I'm running , say an anonymous block:
set serveroutput on
DECLARE
v_stuff varchar2(100):='/bin/env';
BEGIN
SLDPROC.parse_clob(SLDPROC.SHELL(v_stuff));
END;
Is there a way I can see the values of 'v_stuff' in a view or data dictionary table.
Even better, I'm looking a data dictionary table or view that has a column where I can see the value '/bin/env' as it relates to either the SLDPROC.SHELL function or the value of SLDPROC.SHELL(v_stuff) as it relates to the SLDPROC.parse_clob procedure.
Can anyone help?