Debugging Oracle PL/SQL procedures using SQL Developer

1. Start SQL Developer and connect to DBMS.2. Grant:GRANT DEBUG CONNECT SESSION TO some_user;GRANT DEBUG ANY PROCEDURE TO some_user;3. Start remote debug, enter Port and IP address which is accessible from DBMS.4. Execute "execute DBMS_DEBUG_JDWP.CONNECT_TCP('your ip',4000);".5. Select procedure, add breakpoint, compile for debug.6. debug procedure (ctrl+shif+f10), enter IP if needed.

Continue Reading

End of content

No more pages to load

Close Menu