Home » SQL & PL/SQL » SQL & PL/SQL » How to get the name of the column of the table that caused exception while loading data
How to get the name of the column of the table that caused exception while loading data [message #413142] Tue, 14 July 2009 10:02 Go to next message
adusur
Messages: 36
Registered: June 2009
Location: Bhubaneswar
Member
Hi,
I am trying to load the data from one table to another table using
sql procedures and cursors.

My requirement is that, If any exception comes while loading
the data, i need to retrieve the column name taht causing
the exception and put it in the error table
along with table name.

How can i do that.?
Is there any pre defined keyword to retrieve that column name?

Please provide a solution for this as soon as possible.

Thanks in Advance,
Ravi
Re: How to get the name of the column of the table that caused exception while loading data [message #413143 is a reply to message #413142] Tue, 14 July 2009 10:08 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Just use ERROR LOGGING already built into Oracle

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9014.htm#sthref9455
Previous Topic: For loop taking more than 24 hours to complete (merged 4)
Next Topic: Formatting the flat file output using UTL_File
Goto Forum:
  


Current Time: Sun Dec 04 20:59:32 CST 2016

Total time taken to generate the page: 0.05714 seconds