Re: VARCHAR2 Parameter Question
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 26 Sep 2008 14:59:26 -0700 (PDT)
Message-ID: <2e5bffd0-83af-49c2-b2d2-7c4ced3f4ef6@59g2000hsb.googlegroups.com>
Date: Fri, 26 Sep 2008 14:59:26 -0700 (PDT)
Message-ID: <2e5bffd0-83af-49c2-b2d2-7c4ced3f4ef6@59g2000hsb.googlegroups.com>
On Sep 26, 1:19 pm, a..._at_unsu.com wrote:
> Hi,
>
> Does a VARCHAR2 input parameter to a stored procedure have a max
> length? I pass a 465 byte string to a procedure receiving it as a
> varchar2 and it gives some error of the string byte too small or
> something.
>
> I cut it down to 195 and it works fine. I bring it up in TOAD to
> debug it and the parameter shows a value of 200.
>
> Why is that? I thought the max value was 4000.
Post the complete procedure not what you think the spec is ... please. Received on Fri Sep 26 2008 - 16:59:26 CDT