Re: PL SQL Error

From: ddf <oratune_at_msn.com>
Date: Fri, 11 Dec 2009 11:27:10 -0800 (PST)
Message-ID: <ce16fe9d-09a2-482f-a913-48318b478648_at_b36g2000prf.googlegroups.com>



On Dec 11, 2:19 pm, The Magnet <a..._at_unsu.com> wrote:
> On Dec 11, 1:09 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
> > On Dec 11, 10:58 am, The Magnet <a..._at_unsu.com> wrote:
>
> > > This one is kind of confusing.   The max length of a VARCHAR2 is
> > > 4000.  So, I call a stored procedure passing is a value that is 3278
> > > characters long, basically text.  I receive an error:
>
> > > SP2-0027: Input is too long (> 2499 characters)
>
> > > If I code that into a variable inside some code, same thing.
>
> > > Breaking it up is not really an option since it is being called some a
> > > PHP application.  But, if 4000 is the max, why is it complaining at
> > > 3000????
>
> > Documented sqlplus command line limit:http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/apa.ht...
>
> > Note you can find stuff like this in MOS, simply by searching the
> > knowledge base for the error number.
>
> > Does kinda point up that you need to understand the whole tech stack -
> > the clue that it is sqlplus is the SP2 in the error message.
>
> > jg
> > --
> > _at_home.com is bogus.http://technology.amis.nl/blog/6404/oracle-rdbms-11gr2-solving-a-sudo...
>
> Does not make sense, unless I am confusing 2 things.
>
> I have plenty of stored procedure where say I create a dynamic query
> which is like 3500 characters long and there is no problem there.
>
> Why is this an issue?  Is it because it is getting "passed" into the
> stored procedure?- Hide quoted text -
>
> - Show quoted text -

Yes. You're trying to pass a single line with more than 2499 characters through the SQL*Plus interface and that's not possible. It's not the VARCHAR2 length it's complaining about, it's the line length.

David Fitzjarrell Received on Fri Dec 11 2009 - 13:27:10 CST

Original text of this message