PL SQL Error

From: The Magnet <>
Date: Fri, 11 Dec 2009 10:58:53 -0800 (PST)
Message-ID: <>

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???? Received on Fri Dec 11 2009 - 12:58:53 CST

Original text of this message