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

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

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