Re: VARCHAR2 Parameter Question

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 26 Sep 2008 21:31:39 +0200
Message-ID: <48dd3891$0$191$e4fe514c@news.xs4all.nl>

<art_at_unsu.com> schreef in bericht
news:7a557046-61c2-4ddd-947c-fd00b9c82a46_at_2g2000hsn.googlegroups.com... 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
> variable?)
>
> Shakespeare

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.

---

Not here. Just created your proc as
create or replace PROCEDURE add_customer_info (

  p_customer_id  NUMBER,
  p_portfolio_id NUMBER,
  p_tickers      VARCHAR2)

is
begin
  null;
end;

and called it with a 210 and 420 length string. No problems. So without the code and/or version there's no help possible

Shakespeare

BANNER
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Prod PL/SQL Release 10.1.0.5.0 - Production
"CORE 10.1.0.5.0 Production"
TNS for 32-bit Windows: Version 10.1.0.5.0 - Production NLSRTL Version 10.1.0.5.0 - Production Received on Fri Sep 26 2008 - 14:31:39 CDT