dbms_sqldiag.dump_trace

Hello !

I am trying to use dbms_sqldiag.dump_trace, I can use it directly like

SQL> exec dbms_sqldiag.dump_trace(p_sql_id=>'fzcgyvrqshjjq',p_child_number=>0,p_component=>'Compiler',p_file_id=>'mytrcfile');

PL/SQL procedure successfully completed.

but as soon I try to call it from a procedure i created I get an confusing (to me) error

SQL> exec my_dump_10053('fzcgyvrqshjjq',0,'TRACING');

BEGIN my_dump_10053('fzcgyvrqshjjq',0,'TRACING'); END;

*

ERROR at line 1:

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SQLDIAG", line 1555

ORA-06512: at "V074617.MY_DUMP_10053", line 4

ORA-06512: at line 1

My procedure looks like this...