Re: PL SQL Error

From: Tim X <>
Date: Sat, 12 Dec 2009 09:33:41 +1100
Message-ID: <>

The Magnet <> writes:

> 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????

You need to provide

  • Oracle version
  • the procedure being called
  • test case showing calling the procedure and the error
  • the character encodings being used
  • The DDL for any tables involved
tcross (at) rapttech dot com dot au
Received on Fri Dec 11 2009 - 16:33:41 CST

Original text of this message