Clever Geek Handbook

What is the best way to debug Oracle SP?

I am somehow new to Oracle. We have a lot of questions.

We use two main clients to fulfill requests. SqlDeveloper (provided by Oracle) and PL / SQL Developer 7.1.

We are trying to debug a stored procedure. Problems: -

  • There are multiple stored procedures that are compiled with somename.SPNAME means they are in a different schema / or synonym? Therefore, when we enter our DB from SQLDeveloper, we cannot see the stored procs that were compiled with somename.SPNAME.
  • When we enter the same DB with a PL / SQL developer, we can see the aforementioned SP, but we cannot debug anything. By clicking on the Debug toolbar, you will see what has ever been disabled (except setting / changing breakpoints).

So from here we need to solve any of the problems. Either change something in sql developer so that all SPs are shown and then we can debug them (since we know the debugger in SQL developer works) OR make debug work in PL / SQL developer.

I know the question and explanation got a bit verbose, but we are struggling with this issue and can really use some help.

+2


source to share


1 answer


  • For Oracle SQL Developer, you will see other schema objects by extending the "Other Users" node.

  • To debug with PL / SQL Developer, you need the "DEBUG CONNECT SESSION" privilege.



+4


source






More articles:


All Articles