oracle bulk inset utility
I am bulk inserting records from an array to a table i used save exception to record the exception during the bulk insertion. but this utility only gives the error code.then later i fethed error message from the eror code but this message is generic not specific.(not the exact exception message) .i want to know the exact message. for example if any foreign key violation occurs then i want the error message with the constraint name that has been violated.
Is their any utility in oracle that can provide it . i am using oracle 10 g.
Thanks in advance.....
Software/Hardware used:
Software/Hardware used:
ASKED:
August 11, 2009 5:11 AM
UPDATED:
August 11, 2009 1:54 PM
Answer Wiki:
You might need to use the DML error logging feature (but I think it was introduced in 10gR2).
There is an article in Oracle Magazine (march/april 2009) that covers exception handling using the save exceptions feature and the DML error logging feature.
Have a look:
<a href="http://www.oracle.com/technology/oramag/oracle/09-mar/o29plsql.html?_template=/ocom/print">Continue PL/SQL execution beyond exceptions</a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
