Dear All,
EBS Version : R12.2.9
DB Version : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
I am using a Shell Script loader program to load the data. Due to abrupt DB failures such as "SQL*Loader-605", "ORA-12502", the control file did not load the data and the BAD file is not captured/generated. I need to create an exception if any failures happen apart from regular ones and then change the concurrent program state to "Error" instead of "Normal".
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
ORA-12502: TNS:listener received no CONNECT_DATA from client
Using the following SQL Loader Code:-
$i is the filename used for loading.
sqlldr $LOGIN CONTROL=$BIN_DIR/$CONTROLFILE LOG=$LOGFILE/`date "+%d%m%Y%H%M%S"`_$i.log DATA=$i BAD=$BADFILE/PG_`date "+%d%m%Y%H%M%S"`_$i
if test -f $BADFILE/*$i then
EXIT_STATUS=2
fi
Thanks in advance for your assistance.