Skip to Main Content
Forums

SQL & PL/SQL

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!

How to get output parameters in batch file

449485Mar 27 2009 — edited Mar 27 2009
Hi,

I try to create a batch file which execute SQL script.
This SQL script is a PL/SQL and he returns an output parameter

I should like to get this output parameter in the batch file.

That is to say, just after this command

sqlplus usr/password@bdd @my_proc

==> echo my_output_parameter ?

Thanks for yours ideas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2009
Added on Mar 27 2009
4 comments
2,334 views