Database Tuning (MOSC)

MOSC Banner

ORA-01722: invalid number in 10g

edited Apr 9, 2009 11:20PM in Database Tuning (MOSC) 3 commentsAnswered
 Hello, I am getting ORA-01722: invalid number error in 10g, not in 9i.

SELECT COUNT(1) FROM dcsw_owner.STATIC_META_INFO
WHERE LABEL_NAME = 'APL_STATUS'  AND STATUS = 'P' 
AND ACCESS_KEY = 140

or

SELECT COUNT(1) FROM dcsw_owner.STATIC_META_INFO
WHERE LABEL_NAME = 'APL_STATUS'  AND STATUS = 'P' 
AND to_number(ACCESS_KEY) = 140

ORA-01722: invalid numbe

SELECT COUNT(1) FROM dcsw_owner.STATIC_META_INFO
WHERE LABEL_NAME = 'APL_STATUS'  AND STATUS = 'P' 
AND ACCESS_KEY = '140'

No Error now.

In 9i  ALL the three statements work fine. Data of this table in both 9i and 10 is same.

Thank You

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center