OraFAQ Forum: SQL & PL/SQL » How to get the name of the column of the table that caused exception while loading data

Home » SQL & PL/SQL » SQL & PL/SQL » How to get the name of the column of the table that caused exception while loading data

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

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

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

Report message to a moderator