Re: ** ORA-06502

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 10 Feb 2008 20:39:10 -0800
Message-ID: <bf46380802102039t7cf58b8ar865e4122a6f9e251@mail.gmail.com>


Please supply example code that duplicates the error.

On Feb 10, 2008 6:46 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:

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

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 10 2008 - 22:39:10 CST

Original text of this message