2 Replies Latest reply: Apr 18, 2014 7:14 AM by WolfShade

Invalid number (01722) in Oracle 10g

WolfShade Apr 18, 2014 6:13 AM

Hello, everyone,

I have an Oracle 10g database, and in it is a table where the first column is a VARCHAR 36 and contains Oracle generated UIDs.

I am trying to run a SELECT query that gets a corresponding (date 19) where the UID = '{ a 36 character long UID}'. I am getting the ORA-01722 invalid number error message.

SELECT s.ENTERED_DATE

FROM dsp.status s

WHERE s.UID = '4a29d12025012995c231f18eb7704009'

I've tried using TO_CHAR() and CAST() to no avail. What am I missing?

V/r,

^_^

1. Re: Invalid number (01722) in Oracle 10g

BKBK Apr 18, 2014 7:06 AM (in response to WolfShade)

Isn't UID a word that Oracle reserves for a pseudo-column representing an integer?
Like Show 0 Likes (0)

Actions
2. Re: Invalid number (01722) in Oracle 10g

WolfShade Apr 18, 2014 7:14 AM (in response to BKBK)
If I'd been 6 minutes quicker..

I just discovered that putting UID in double-quotes will allow the query to run without issue.

SELECT s.ENTERED_DATE FROM dsp.status s WHERE s."UID" = '4a29d12025012995c231f18eb7704009'

Sigh.. you'd think that a database as old and robust as Oracle would be able to be a bit more specific with the error messages.

Thanks, @BKBK.

^_^
Like Show 0 Likes (0)

Actions

Go to original post

Legend

Correct Answers - 10 points