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


   Am Using Oracle Version


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.




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