** ORA-06502

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Sun, 10 Feb 2008 18:46:38 -0800 (PST)
Message-ID: <767589.55539.qm@web58003.mail.re3.yahoo.com>

  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.

http://www.freelists.org/webpage/oracle-l Received on Sun Feb 10 2008 - 20:46:38 CST

Original text of this message