5 Replies Latest reply: Jun 19, 2013 1:50 AM by Marwim RSS

    ORA-01722: invalid number

    Efficientoracle

      Hi,

         Am Using Oracle Version 11.2.0.2

       

      Am facing a Issue ORA-01722: invalid number with the below

       

      Select no_Of_Outs from Table a where a .session_id =6178567;

       

      Session_Id Field is Of Varchar2(30) Datatype.

       

      This error is not coming for all scenarios. Some times it occurs.Some time it doesn't.

       

      Where can i dig for such scenario.


      Regards,

      Simma...