• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Invalid number (01722) in Oracle 10g

LEGEND ,
Apr 18, 2014 Apr 18, 2014

Copy link to clipboard

Copied

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,

^_^

Views

492

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Apr 18, 2014 Apr 18, 2014

Isn't UID a word that Oracle reserves for a pseudo-column representing an integer?

Votes

Translate

Translate
Community Expert ,
Apr 18, 2014 Apr 18, 2014

Copy link to clipboard

Copied

Isn't UID a word that Oracle reserves for a pseudo-column representing an integer?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 18, 2014 Apr 18, 2014

Copy link to clipboard

Copied

LATEST

  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.

^_^

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation