Start the debugger by selecting Run|Debug option.

Once JDeveloper attaches to the Aurora VM agent in Oracle8i the Java Stored Procedure execution stops at the specified breakpoint.

The threads pane(top left) shows the thread stack during the execution of Java Stored Procedure.

The structure pane(bottom left) shows the values of different variables at the breakpoint.

At this point you would be able debug the Java Stored Procedure running in Oracle8i with the ability to step through code one statement or procedure at a time and display the values of variables and properties.

The debugger related messages can be seen in the MessageViewer as seen in the figure.

Note:- You must grant permission to your database user before you can debug server-side Java within Oracle8i. To do this, log into the database as a DBA user, such as system using SQL*Plus or its equivalent. call dbms_java.grant_permission('SCOTT', 'SYS:oracle.aurora.security.JServerPermission', 'Debug' ,null);