Re: ORA-06502: PL/SQL: numeric or value error

From: <spareway_at_my-deja.com>
Date: 2000/04/08
Message-ID: <8cobt3$ded$1@nnrp1.deja.com>#1/1

mark,

I am using Oracle 8 on NT. My problem has to do with using a varchar2 as a parameter in a stored proc. For example the follwing procedure will give me an ORA-06502: PL/SQL: numeric or value error.

PROCEDURE atest(

p_Out out varchar2)
is

        xyz varchar2(32000);
begin
  xyz:= rpad('z',256);
  p_out:=xyz;
end;

There seems to be a 256 character limit on p_Out. Is there a workaround?

thanks,

Craig

In article <1a737818.893de75e_at_usw-ex0103-024.remarq.com>, mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid> wrote:
> You forgot to post your procedure. Maybe we will be able to spot
> something.
> Also, the max sizes of varchar2 varies depending on your oracle
> version. Which version are you?
>
> Mark
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> The fastest and easiest way to search and participate in Usenet -
Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Apr 08 2000 - 00:00:00 CDT