Getting Return Values from PL/SQL

[mjm22]

Hi

I have a unix script which produces the following pl/sql file on the fly before running it...

set serveroutput on

DECLARE
errValue NUMBER;
BEGIN

errValue := IPGPPP.insertAuditTrailRecords(1,0,'&&1','&&2','&&3','&&4',6,1639054);
END;
/

exit;


I want to return the errValue to the Unix script in order to do some error checking. Currently this script is called with a simple sqlplus command....

sqlplus $DATABASE @tempSQL.sql $TO_REF_FILE $FILEDTM $PPPNNI $PPPPID

How can I get the value returned by the Oracle Function back into a variable in the Unix script?

Thanks in advance

Mike

 

[dickiebird]

I would take a look at faq822-2218 and the one below it.
HTH

Dickie Bird (-)))