RE: sqlldr

From: Vordos, Suzy <Suzy.Vordos_at_qwest.com>
Date: Mon, 14 Dec 2009 09:52:18 -0700
Message-ID: <F9BAF589B638564EBCF9495B0CE1C89805D6C07E43_at_qtdenexmbm24.AD.QINTRA.COM>



You could check results of $? for the return code.

# 0 = ex_succ all rows loaded
# 1 = ex_fail fatal errors, syntax/command line errors
# 2 = ex_warn some rows rejected/discarded
# 3 = ex_ftl os related errors



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Noor Mulla Sent: Monday, December 14, 2009 1:35 AM
To: oracle-l-admins_at_freelists.org; oracle-l_at_freelists.org Subject: sqlldr

Hi,

We have SQLLDR SHELL programs that are generated in which there is a line for each sqlldr load job. We need to monitor or check the results of each load job when it finishes to see if there were any load errors. This can be either incorporated into the generated sqlldr SHELL program such that one line would be added after each sqlldr invocation. This line could check the log file for any errors and send email to our group showing error(s) if any exist.

Thanks & Regards
Noor M Mulla
HCLT - Bangalore

DISCLAIMER:


The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect.




This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 14 2009 - 10:52:18 CST

Original text of this message