Returning Value to UNIX Command Line

[gsprince]

Try this:

DECLARE
RetVal NUMBER;
BEGIN
RetVal := ODSLOAD.FUNC_EXTRACT_TRAILER ( 1 );
END;
/ -- Added
exit :RetVal; -- Added

And, test the value of "$?"