Calling SQL Loader from Unix

[jones54]

Hi,

I have a Unix script, from which I call SQL Loader to load data into an Oracle database. I then want to run some more commands after this but only if the SQL Loader insert completed successfully.

Is there any way I can tell from my Unix Script whether or not the SQL Loader insert completed successfully?

Any ideas or suggestions appreciated.

Thanks

 

[LKBrwnDBA]

You could try checking for $? return code after sqlldr executes.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

-- OR --

Grep the sqlldr log:

rr=0; rd=0; err=0;
typeset -i rr=`grep "Total logical records rejected:" MySqlldr.log|awk '{print $5;}'`
typeset -i rd=`grep "Total logical records discarded:" MySqlldr.log|awk '{print $5;}'`
((err=rr+rc))
if [ err -gt 0 ]
then
echo "$err Errors."
fi


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[jones54]

Thanks for your help LKBrwnDBA

Your first suggestion seems to work.

I tried a few scenarios and it returns an error code greater than zero if there is any problem with the SQL Load e.g. primary key violation, incorrect password, incorrect instance name ....