Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get date column name in the error message in the error logging table

vballedaFeb 25 2015 — edited Feb 25 2015

Hi All ,

I have  a table  on which I am doing  insert and update operations . I am using error logging table to catch all the errors  Table consists 5 date columns . In which 2 are error  out for some reasons but I am not able to get the date column name on which it is error  out . I am simply getting  the error 'literal does not match format string' .

Can some one please help me how to get date column name in the error message in the error logging table

I am using oracle 10g ,

os windows 7 .

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2015
Added on Feb 25 2015
11 comments
554 views