Re: PL SQL Error

From: Tim X <timx_at_nospam.dev.null>
Date: Sat, 12 Dec 2009 09:33:41 +1100
Message-ID: <87fx7h87ju.fsf_at_lion.rapttech.com.au>

The Magnet <art_at_unsu.com> 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