RE: ** ORA-06502

Joshi,  

What is the size of the receiving parameter and how much data are you storing into it?

for example:  

In your calling procedure, you declared something like:  

calling_str varchar2(1);  

begin
procedure f_name_for_empid( 1,calling_str); end;

If the f_name_for_empid procedure passes back anything larger than varchar2(1), then you get the 6502 error. If you increase the size of the declaration of calling_str to varchar2(100) (or some other reasonable value) then the error would probably go away.

Tom

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A Joshi Sent: Sunday, February 10, 2008 9:47 PM
To: oracle-l_at_freelists.org
Subject: ** ORA-06502

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://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsear ch/category.php?category=shopping>

--
http://www.freelists.org/webpage/oracle-l