OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » error capturing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error capturing [message #173466]

Mon, 22 May 2006 10:59

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

Frank Naude
Messages: 4581
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 15:20:11 CST 2024