Skip to Main Content

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!

REturn Value From Function into Bat File

589456Jul 23 2007 — edited Jul 24 2007
Hi,
i've the following scenario:

I've a PLSQL function:

function TEST
RETURN VARCHAR2 as
begin
return 'A';
end;


I would loke to call this function from DOS Batch file, by using sqlplus.exe.

There is a method to obtain the return value into a Dos Bacth file variable?

example:
file: Example.bat
sqlplus.exe ***** TEST **** %Variable%
echo %Variable%


Thanks!!!
Emiliano
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2007
Added on Jul 23 2007
2 comments
614 views