** ORA-06502

  • From: A Joshi <ajoshi977@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 10 Feb 2008 18:46:38 -0800 (PST)

Hi, 
  I have a stored procedure with a out parameter defined as : 

procedure f_name_for_empid( 
empid in number, 
f_name out varchar2 ) 

For some reason I am getting error ORA-06502 in the statement where I am  
setting f_name. I am able to set it to one char. However, if I set it to two or 
more char it gives error ORA-06502. I have similar bigger SP and all looks 
fine. Does anyone have similar experience and what could be reason. Thanks


       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.

Other related posts: