Re: ** ORA-06502
Date: Sun, 10 Feb 2008 20:39:10 -0800
Please supply example code that duplicates the error.
On Feb 10, 2008 6:46 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:
> 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.
> Looking for last minute shopping deals? Find them fast with Yahoo! Search.<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 10 2008 - 22:39:10 CST