Search Results

yup got that...thnks..

Hi all

Im trying to call a PL SQl block from a ksh file like this :

sqlplus -s $DB_USERID/$DB_PASSWD@$DB_NAME<<eof
whenever SQLERROR exit 1
var varError VARCHAR2(200);
exec...

Hi all

Im calling a DB procedure as foll

sqlplus -s $DB_USERID/$DB_PASSWD@$DB_NAME<<eof
var var1 VARCHAR2(200);
exec ODAS_BATCH_JOBS_RETRIEVE.retrieve_user_info(:var1);
eof

echo $var1
...