SQL Loader return types [message #368306] |
Tue, 07 November 2000 12:57 |
Siddartha
Messages: 2 Registered: November 2000
|
Junior Member |
|
|
I am using Oracle on Unix and I want to know what values are returned when sqlldr is run - For eg successful completion returns 0. I just want a list of return values and a description for each
Thanks
|
|
|
Re: SQL Loader return types [message #368318 is a reply to message #368306] |
Fri, 10 November 2000 11:44 |
M.Moore
Messages: 1 Registered: November 2000
|
Junior Member |
|
|
if you are running from a unix shell script,
just check for zero (0) after execution of your
sqllrd statement:
in a shell script
sqllrd user/pass@db xxx.ctl xxx.dat
if [[ $? -eq 0 ]]
then
echo "Load Complete"
else
echo "Load Failed"
fi
this works for us.
|
|
|