Testing Stored Procedures

You can test stored procedures you have deployed to Oracle Database by running an application that executes those procedures or by running any SQL client tool. These SQL client tools can be invoked from within JDeveloper:

SQL Worksheet
SQL*Plus

All testing and running of applications must include a connection to the database that accesses the user name space into which the Java Stored Procedures are deployed.

Test stored procedures depending on how they are deployed:

In packages
Separately