Re: ORA-06502 at runtime?

From: codadilupo <>
Date: Wed, 13 Feb 2008 17:12:10 +0100
Message-ID: <47b316da$0$16040$>

sybrandb wrote:

> Your 'constant' is varchar2 and you return a varchar.
> While varchar does exist as a datatype, it has never been in use, and
> even Oracle recommends not to use it.
> This might be a 'hole' in PL/SQL, which you would need to verify from
> Metalink.
> As you are not on the latest patchlevel and Oracle removed 9i from
> premier support, this potential bug is not going to be resolved.

Just FYI, has the same behaviour, even if you use the varchar2 datatype everywhere.

This seems to be Oracle standard behaviour.

C. Received on Wed Feb 13 2008 - 10:12:10 CST

Original text of this message