Hi,

I am calling SQLPLUS from the UNIX command line with the following command:

SQLPLUS odsload/odsload@odsd.com @value.sql


The value.sql file is the following:

DECLARE
RetVal NUMBER;
BEGIN
RetVal := ODSLOAD.FUNC_EXTRACT_TRAILER ( 1 );
END;


Now, my question is how do I return the value RetVal to the UNIX command line?

Thanks in advance, Keith