I am running a dos script that calls sqlplus to execute a sql script.

The sql script executes a stored procedure. The stored procedure
returns an output parameter ( err message). How do I capture
the output parameter in the sql script? Can I pass that value back to the dos script?

Thank you for your help,