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

From: Girts Graudins <ggraudins_at_my-deja.com>
Date: 2000/04/06
Message-ID: <8cis8o$jq7$1@nnrp1.deja.com>#1/1

> When i assign a large string(less than 32000 characters) to
> the varchar2 i get a ORA-06502: PL/SQL: numeric or value error. I
> suspect that there is a default size for a varchar out parameter,since
> a small string has no problem. Is there any way to change that efault
> size of this paramter?

There are two limitations. The largest VARCHAR2 that you can insert into the database is 4000 characters long. The largest VARCHAR2 that you can declare as a PL/SQL variable is 32767 long. If your strings are larger than that, you'll have to consider a different data type.

---

Girts Graudins
Consulant
The Exeter Group, Inc.
ggraudins_at_hotmail.com
http://www.exetergroup.com/

---

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