Re: VARCHAR2 Parameter Question

<art_at_unsu.com> schreef in bericht
news:f7df28cf-e38a-4e40-bee3-b55860c238a1_at_m73g2000hsh.googlegroups.com...
> 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.

John, art, arthur, artmerar, Mtek, exec:

No version, no code..

Could be something INSIDE the procedure (does it assign the parameter to a variable?)

Shakespeare Received on Fri Sep 26 2008 - 13:15:42 CDT