Re: VARCHAR2 Parameter Question
Date: Fri, 26 Sep 2008 22:51:06 +0200
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 DBAReceived on Fri Sep 26 2008 - 15:51:06 CDT