Home » RDBMS Server » Performance Tuning » error capturing
error capturing [message #173466] Mon, 22 May 2006 10:59 Go to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
Hi,
I have an insert statement as mentioned below.

INSERT INTO table T (SELECT * FROM T);

Can you please tell me how to capture the occured error during this insert statement. I would like to know the record which caused this error rather than type of error encountered. I dont want to use select into cursor and then use bulk insert.


Is there any way?

Thanks in advance.

Report message to a moderator

Re: error capturing [message #173469 is a reply to message #173466] Mon, 22 May 2006 11:11 Go to previous message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
This might help - http://www.orafaq.com/node/76

Report message to a moderator

Previous Topic: SQL code block running v.v.v. slow
Next Topic: Tuning SQL scripts that uses partitioned tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 03 10:10:25 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.