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!

Best way to solve ORA-01722: invalid number

166038Mar 18 2005 — edited Mar 18 2005

Hi,

I recently had to debug a large Merge statement that was getting 'ORA-01722: invalid number' and I found the only way to do it was comment out the columns until I found the culprit :-(

Surely in this day and age there is a better way to do this? Oracle knows which column fails so it there a way of finding it more quickly?

We are using Oracle 9.2

Thanks for any top tips

Regards

Gary

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2005

Added on Mar 18 2005

2 comments

259 views