Skip to Main Content

Oracle Database Discussions

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!

ORA-1722 Invalid number

427492Aug 21 2007 — edited Aug 21 2007
When I execute the query, I do not get the error:

SELECT claim_header_sid, '2' AS "table_area"
FROM claim_header
WHERE tcn = 002006073000410000

But, if I execute:

SELECT claim_header_sid, '2' AS "table_area"
FROM ad_claim_header
WHERE tcn = 002006073000410000

I get the error, unless if I put single quotes for the tcn value.
What could be the problem? The datatype is varchar2(21 bytes).

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2007
Added on Aug 21 2007
5 comments
340 views