1 Reply Latest reply: Jul 14, 2013 10:40 AM by Jim Smith RSS

    How to Debug PL/SQL in SQL Developer?

    user13034857

      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

        • 1. Re: How to Debug PL/SQL in SQL Developer?
          Jim Smith

          You need to get the DBA for the database to grant your account the privileges mentioned in the error message.

           

          Once that is done it should just work.

           

          Make sure you compile for debug

          You need some way to stop the debugger from just running through the code to the end

            - either set breakpoints

            - or Use Tools|Preferences|Debugger|Start Debugging Option to Step Into.