Calling Oracle Stored Procedures and Functions

Calling an Oracle function is quite simple. For example

SELECT package.register(1, "Frank", "Kim") FROM dual;

However calling Oracle stored procedures is a bit more tricky, especially if the Oracle stored procedure has output parameters. Here is an example of how to call an Oracle stored procedure that has three input parameters and two output parameters.

DECLARE p_credit_status_out INTEGER;
p_school_status_out INTEGER;

package.get_status(1, "Frank", "Kim", p_credit_status_out, p_school_status_out);

Leave a Reply

Your email address will not be published. Required fields are marked *