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.