Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [02-2008 Date Index] [Date Next] || [Thread Prev] [02-2008 Thread Index] [Thread Next]

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




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.