This discussion is archived
5 Replies Latest reply: Jun 18, 2013 11:50 PM by Marwim RSS

ORA-01722: invalid number

Efficientoracle Journeyer
Currently Being Moderated

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...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points