How to debug stored procedures in Oracle PL/SQL ?

Question

How to debug stored procedures in Oracle PL/SQL ?

Let suppose you have 10k lines code in stored procedure and you are getting error

What approach you will take to identify the problem ?

Answer 1

Right-Click the PL/SQL object that you want to debug.

Select the database tools

Select recompile

In the recompile dialog box select debug option

Click OK

You can use TRY CATCH approach to identify the errors.