OraFAQ Forum: Server Utilities » running sql loader from unix shell script

Home » RDBMS Server » Server Utilities » running sql loader from unix shell script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

running sql loader from unix shell script [message #199003]

Thu, 19 October 2006 10:23

roopla
Messages: 52
Registered: May 2006

Member

I am trying capture error code from sql loader from unix shell script and display proper messages.

sqlldr parfile=sdb.par control=$cntlfile data=$infile bad=$badFile log=$logFile rows=10000
rows=10000
retcode=`echo $?`
case "$retcode" in
0) echo "SQL*Loader execution successful" ;;
1) echo "SQL*Loader execution exited with EX_FAIL, see logfile" ;;
2) echo "SQL*Loader execution exited with EX_WARN, see logfile" ;;
3) echo "SQL*Loader execution encountered a fatal error" ;;
*) echo "unknown return code";;
esac

Eventhough, there are errors while executing sqlldr, it is always returing recode zero. What could be the possible reason

Please advice

Report message to a moderator

Re: running sql loader from unix shell script [message #199018 is a reply to message #199003]

Thu, 19 October 2006 11:57

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Not sure why. I just ran sqlldr and specified a non-existant control file and of course it failed and the return code was '1'.

You should try to just set retcode=$?

Report message to a moderator

Previous Topic:	Insert diacritic marks
Next Topic:	execute immediate with Alter user statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 15:56:28 CDT 2024