VARCHAR2 Parameter Question
From: <art_at_unsu.com>
Date: Fri, 26 Sep 2008 10:19:15 -0700 (PDT)
Message-ID: <f7df28cf-e38a-4e40-bee3-b55860c238a1@m73g2000hsh.googlegroups.com>
Date: Fri, 26 Sep 2008 10:19:15 -0700 (PDT)
Message-ID: <f7df28cf-e38a-4e40-bee3-b55860c238a1@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. Received on Fri Sep 26 2008 - 12:19:15 CDT