Re: PL SQL Error
Date: Fri, 11 Dec 2009 11:19:40 -0800 (PST)
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.
> _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? Received on Fri Dec 11 2009 - 13:19:40 CST