Re: VARCHAR2 Parameter Question

"hpuxrac" <johnbhurley_at_sbcglobal.net> schreef in bericht news:2e5bffd0-83af-49c2-b2d2-7c4ced3f4ef6_at_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.

Knowing the OP's reputation on this forum we will never get the details.

Shakespeare Received on Sat Sep 27 2008 - 05:43:23 CDT