Re: VARCHAR2 Parameter Question
Date: Fri, 26 Sep 2008 11:58:14 -0700 (PDT)
On Sep 26, 1:15 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <a..._at_unsu.com> schreef in berichtnews: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
It is a simple procedure like this:
PROCEDURE add_customer_info (
p_customer_id NUMBER, p_portfolio_id NUMBER, p_tickers VARCHAR2);
That varchar2 seems to be limited to 200 characters. Received on Fri Sep 26 2008 - 13:58:14 CDT