Re: Determining Which Row Failed In Insert ... Select Without Using A Cursor

On Sat, 03 Mar 2001 16:51:37 GMT, gteets_at_rr.cinci.com (Greg Teets) wrote:

>Ted,
>
>I know how to do that.
>
>The question is can you find out without
>inserting one line at a time via the cursor.

I don't think there is a built-in function to do that right now. I believe it is a known requirement.

BTW, you can do faster inserts from PL/SQL using the FORALL statement to iterate through the cursor.

John Received on Mon Mar 05 2001 - 04:00:35 CST