| Bulk Exception giving incomplete Information. [message #115251] |
Fri, 08 April 2005 07:46  |
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  |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
