Debugging Oracle package does not stop at breakpoint
I have the following structure:
The PCK_LANCAMENTOSERVICO package under a procedure called P_Integra.
This procedure calls another procedure in another PCK_LANCAMENTO package called P_BeforeLancamento
The P_BeforeLancamento procedure calls another procedure called P_ProximoLanc in PCK_UTIL
I am debugging the P_Integra (PCK_LANCAMENTOSERVICO) routine. Putting a breakpoint in the P_Integra routine works fine. If you put a breakpoint in the P_ProximoLanc procedure, it works fine. But if you dot p_BeforeLancamento, the debugger will not stop at the breakpoint.
I have added debug information to all packages. The PCK_LANCAMENTOSERVICO package has 500 lines. The PCK_LANCAMENTO package has 4000 lines and the PCK_UTIL package has 300 lines.
The debugger does not work in SQL Developer nor in PL / SQL Developer.
Is there a problem with this question? Packing size? Or something else?
Thank you so much
Andre
source to share
You may have permission to execute the procedure, but not debug. Look at the results of this query:
select *
from all_tab_privs
where privilege in ('EXECUTE', 'DEBUG')
and table_name in ('PCK_LANCAMENTOSERVICO', 'PCK_LANCAMENTO', 'PCK_UTIL');
If DEBUG
not, dogrant debug on PCK_LANCAMENTO to <your_user>;
source to share