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>