Re: VARCHAR2 Parameter Question

From: Shakespeare <>
Date: Sat, 27 Sep 2008 12:43:23 +0200
Message-ID: <48de0e4e$0$187$>

"hpuxrac" <> schreef in bericht === On Sep 26, 1:19 pm, 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

Original text of this message