PL SQL Error
From: The Magnet <art_at_unsu.com>
Date: Fri, 11 Dec 2009 10:58:53 -0800 (PST)
Message-ID: <a2de828a-6de9-49e7-8060-fde8631eeafe_at_m3g2000yqf.googlegroups.com>
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:
Date: Fri, 11 Dec 2009 10:58:53 -0800 (PST)
Message-ID: <a2de828a-6de9-49e7-8060-fde8631eeafe_at_m3g2000yqf.googlegroups.com>
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