Re: How sql loader handle the error throw back from DB?

What do you mean by "crash"? What crashed? How? Is sqlldr loading the data fine into you view (insert errors should be caught by your sqlldr error log file), then there are problems when the trigger pops the data into the table? (btw, are you using an "instead of" trigger?). If that's the case, have you coded an exception handler into the trigger itself to catch and/or redirect errors?
Or is there something else involved with your loading process?

C Chang wrote:
>
> 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

-- 
 -----------------------------
* http://pipers.hypermart.net *
 -----------------------------