Executing procedure, after having toggled on SQL Profiler, does not prompt for profiler comments and the run doesn't show up in Database | Optimize | DBMS Profiler Analysis. The Server Side Objects were run to create the Profiler tables and there is a Grant Execute on DBMS_Profiler.
e.g.
DECLARE
INVAL NUMBER;
BEGIN
INVAL := 1;
LOOPPROC ( INVAL ); ** Prodecure is executed without running DBMS_Profiler
COMMIT;
END;
Procedure is being executed within an anonymous block.
Execute procedure directly by either loading the procedure into the editor and clicking on the icon 'Execute PLSQL with debugger' or F11 or Debug menu | Run, or executing the procedure directly from Schema Browser (Note, you can insert additional sql statements in the anonymous block in the set parameters window)
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center