Re: VARCHAR2 Parameter Question

From: <>
Date: Fri, 26 Sep 2008 22:51:06 +0200
Message-ID: <>

On Fri, 26 Sep 2008 13:45:09 -0700 (PDT), wrote:

>I did not see anything on the net about a max length of it, other than
>some references to 32k.....

You didn't see anything about a max length because there IS no max length, apart from in your imagination.
varchar2 variables in pl/sql have a max length of 32767 characters (or bytes depending on which character semantics you are using), and that is a documented limit.

Look buddy, if you want help, you need to show *exact* code and *exact* error messages, and *version info*. If you are not prepared to post that, because that is too much trouble, please goto, they specialise in dealing with lazy dbas and developers.

Sybrand Bakker
Senior Oracle DBA
Received on Fri Sep 26 2008 - 15:51:06 CDT

Original text of this message