Re: VARCHAR2 Parameter Question

On Sep 26, 2:31 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <a..._at_unsu.com> schreef in berichtnews: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- Hide quoted text -
>
> - Show quoted text -

Sorry.

We are running 10g R2.....

Actually it was 190 character string worked fine. But 420 bombed.

I did not see anything on the net about a max length of it, other than some references to 32k..... Received on Fri Sep 26 2008 - 15:45:09 CDT