RE: ** ORA-06502

From: Mercadante, Thomas F (LABOR) <>
Date: Mon, 11 Feb 2008 08:42:05 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF019F02EF@EXCNYSM0A1AJ.nysemail.nyenet>


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);  

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.


[] On Behalf Of A Joshi Sent: Sunday, February 10, 2008 9:47 PM
Subject: ** ORA-06502

  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.
<* ch/category.php?category=shopping>

Received on Mon Feb 11 2008 - 07:42:05 CST

Original text of this message