Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Output-Parameter of a stored procedure

694200Apr 14 2009 — edited Apr 15 2009

Hi,

I want to execute a stored procedure. There are 2 IN-parameters (integer, integer) and 1 out-parameter (boolean).
I want to run this stored procedure from VBA to get back the boolean TRUE or FALSE.

But how can I get back the parameter?
On executing with SQL-tools I tried it in this way:

EXECUTE SP_test123 (1,2)

But there is the following error-message:
ORA-06550: wrong number or types of arguments in call to 'SP_test123'

How can I get the output-parameter after execution of the stored procedure?

Best regards,

Tim

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2009

Added on Apr 14 2009

#general-database-discussions

12 comments

10,957 views