FreeLists / oracle-l / RE: ** ORA-06502

["Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of A Joshi
Sent: Sunday, February 10, 2008 9:47 PM
To: oracle-l@xxxxxxxxxxxxx
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>