OraFAQ Forum: Server Utilities » Return value from SQL Loader command

Home » RDBMS Server » Server Utilities » Return value from SQL Loader command

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

Return value from SQL Loader command [message #73653]

Sat, 12 June 2004 03:26

Manikandan
Messages: 7
Registered: October 2000

Junior Member

Hi,

�� I am calling sql loader from the unix shell script. Though the command append data into the table it returns 2 rather 0 even for successful operation. I used silent=all option too.But i cud not get 0 as return value. Please guide me how to get a 0 as return value for successful operation.

sqlldr UserId/pwd control=load.ctl data = $1 silent=all

if [[ $? -eq 0 ]]

then

........

�

Thanks

~M~

Report message to a moderator

Re: Return value from SQL Loader command [message #73659 is a reply to message #73653]

Mon, 14 June 2004 04:18

Frank Naude
Messages: 4589
Registered: April 1998

Senior Member

Hi,

If you are running Oracle 8 (or above) on a Unix platform, you can test against the following sqlldr exit codes:

0 = Successful
1 = Unrecoverable failure
2 = At least one row rejected
3 = O/S Errors

If this doesn't work, you can always "grep" for errors in the log file.

Best regards.

Frank

Report message to a moderator

Re: Return value from SQL Loader command [message #73661 is a reply to message #73653]

Mon, 14 June 2004 04:44

Frank Naude
Messages: 4589
Registered: April 1998

Senior Member

Also see this thread - SQLLdr Return Code

Best regards.

Frank

Report message to a moderator

Previous Topic:	Newbie- what is a data disk?
Next Topic:	The BUFFER parameter on IMPORT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 07:31:50 CST 2025