Home » RDBMS Server » Performance Tuning » Bulk Exception giving incomplete Information.
Bulk Exception giving incomplete Information. [message #115251] Fri, 08 April 2005 07:46 Go to next message
abc123
Messages: 24
Registered: March 2005
Location: sa
Junior Member
When i use BULK INSERT with SAVE EXCEPTION option, and then try to insert the error message into an error table, i get incomplete error message.
That is if normally error is:
ORA-00001: unique constraint (table.column) violated

then with bulk method it only give error like:
ORA-00001: unique constraint (.)violated

It does not give any information as to which column caused the error.This is the case with all other system generated error.

Is there any way to get the missing information.
Please Help.
Re: Bulk Exception giving incomplete Information. [message #115458 is a reply to message #115251] Mon, 11 April 2005 14:44 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
You are using SQL%BULK_EXCEPTIONS.COUNT, SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, and SQL%BULK_EXCEPTIONS(i).ERROR_CODE, right?

Also, you can look at the columns that make up the constraint in user_cons_columns.

Is this what you are asking?
Re: Bulk Exception giving incomplete Information. [message #115526 is a reply to message #115251] Tue, 12 April 2005 08:44 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
For a little more on this, check out this thread, particularly towards the bottom, on asktom:

http://asktom.oracle.com/pls/ask/f?p=4950:8:242148689997662036::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3675533064673
Previous Topic: disk partition strategy for best performance...
Next Topic: Statspack Report
Goto Forum:
  


Current Time: Wed Sep 30 10:28:06 CDT 2020