Hi Experts,
I have a PLsql procedure with the below specification-
PROCEDURE SEND_INV_VIA_EMAIL (p_pdf_file_name IN VARCHAR2,p_submitted_frm IN VARCHAR2);
I can pass the two in parameters from SHELL script and it is working fine-
# Calling the PLSQL procedure
sqlplus -s $APPS_USER <<EOSQL
SET SERVEROUTPUT ON SIZE 1000000
whenever sqlerror exit 1;
execute MOB_XMLPUB_ARCHIVE_ARINV_PCK.send_inv_via_email('`basename $DATA_FILE`','ARCHIVE');
exit;
EOSQL
But now i want to have an out parameter in the plsql procedure-
PROCEDURE SEND_INV_VIA_EMAIL (p_pdf_file_name IN VARCHAR2,p_submitted_frm IN VARCHAR2,p_return_status IN OUT VARCHAR2);
based on this i want to determine the concurrent request completion status since shell script is getting called via concurrent program.
how will i pass out parameter from shell and How can i use this out parameter in SHELL script to determine completion status?
Many thanks.
Vikrant