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

    Invalid number (01722) in Oracle 10g

    WolfShade Level 4

      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.

      FROM dsp.status s
      WHERE s.UID = '4a29d12025012995c231f18eb7704009'



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