Toad World® Forums

How to run a procedure from a Package in Toad for Oracle?

Greetings,

How can I run a procedure, say get_pay_period_end_date, from a package called Payroll in Toad for Oracle? There are 3 passing parameters from the calling program that calls the procedure: current_year, past_year, err_code.

Thanks in advance for any and all the help.

From the browser, click on your package.

Hit the execute button.

In the popup window, select your procedure. Then supply the inputs.

Similar steps if you load the package in the editor first.

jeff

Fantastic information and thanks a lot Jeff.