The following example gives detailed steps of remote debugging Java Stored Procedures in Oracle8i Release2 (8.1.6).

For this example, we have a Project 'REMOTEDEBUGGINGJSPROC' already loaded into the IDE.

The Java Stored Procedure has a two methods 'getPrimes' which returns the first 10 prime numbers and 'debug_main' which calls 'getPrimes'.

Note:- Oracle8i Release2 is required for remote debugging EJB.The stored procedure should have a 'debug_main' method which is declared as public static void. This method will be used as the entrypoint for the debugging session.