Home » RDBMS Server » Server Utilities » SQL Loader return types
SQL Loader return types [message #368306] Tue, 07 November 2000 12:57 Go to next message
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 Go to previous message
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.
Previous Topic: Oracle webassitant
Next Topic: character set
Goto Forum:
  


Current Time: Fri Mar 29 00:22:02 CDT 2024