Re: VARCHAR2 Parameter Question

On Fri, 26 Sep 2008 13:45:09 -0700 (PDT), art_at_unsu.com 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 http://forums.oracle.com, they specialise in dealing with lazy dbas and developers.

-- 
Sybrand Bakker
Senior Oracle DBA