How Do You Call a Procedure in Unix Shell Script?
Contents How Do You Call a Procedure in Shell Script? Calling Oracle Pl/Sql Stored Procedure from a Shell Script – Example. the Following Shell Script Will...
How do you call a procedure in shell script?
Calling Oracle PL/SQL Stored Procedure from a Shell Script – Example. The following shell script will call an Oracle stored procedure compute_sal by passing a parameter employee number as l_empno. The variable l_empno will take the first parameter value passed to the shell script.
Must Read
How do you execute a stored procedure in Unix shell script?
Invoking Oracle stored procedure in unix shell script
cd $ORACLE_HOME/bin Retval=`sqlplus -s <<eof $TPDB_USER/[email protected]$TPD_DBCONN whenever SQLERROR exit 2 rollback whenever OSERROR exit 3 rollback set serveroutput on set pages 999 var status_desc char(200) var status_code…
Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.
