Testing Stored Procedures Deployed Separately

For stored procedures deployed separately (not in packages), access the stored procedure by the stored procedure name set during deployment. The stored procedure name may be the default name taken from the method name or a name chosen for the stored procedure during deployment. Refer to Selecting Methods and Deployment Type for more information about stored procedure naming.

For example, for a public static method hello() that was deployed as hello from a class greeting and package welcome, you could execute a PL/SQL query to the deployed stored procedure that returns the result.

Assume the above hello() method as the example method, but this time assume it was deployed without a package.

With a working connection to the database, your SQL*Plus client could execute the following:




select Openings.Hello() from dual;



Openings.Hello()

The executed code displays:




Hello World!