Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Debug PL/SQL in SQL Developer?

user13034857Jul 13 2013 — edited Jul 13 2013

I am not able to debug PL/SQL and i have following error please advice how I can enable privileges and I want to know the steps of debugging.

Connecting to the database My_connection.

Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68

ORA-06512: at line 1

This session requires DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges.

Process exited.

Disconnecting from the database My_connection.

Thanks for your time

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2013
Added on Jul 13 2013
1 comment
544 views