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!

Best way to debug "ORA-01722: invalid number" from SELECT statement

JackKMar 2 2023

Hi All.
I have a general question. Suppose, one have a SELECT statement that is failing with ORA-01722 error. What is the best way to find out which row is triggering the error?

DB version in propably not needed here, but I am using 19.0.0.0.

Thanks in advance and best regards,
Jacek

Comments
Post Details
Added on Mar 2 2023
8 comments
16,306 views