Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How sql loader handle the error throw back from DB?

How sql loader handle the error throw back from DB?

From: C Chang <cschang_at_maxinter.net>
Date: Sat, 27 Apr 2002 10:49:10 -0400
Message-ID: <3CCABA66.FD4@maxinter.net>


I have an batch file using the sqlldr to insert raw data into a view, which triggers an insert into a real table. Apparently I did not have some exception in that procedure to handle the insert error. So when it crash, it caused the sqlldr failed and since there is no handle, so it generated a Dr. Waston error on screen. I want to know is there an error handling by sql loader? ( I know I can handle the exception inside the sql procedure) but what if I still miss somthing. Thanks

C Chang Received on Sat Apr 27 2002 - 09:49:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US