Prev: VARCHAR2 Length
Next: "Business Logic / Rules should never be in the database or storedprocedures"
From: Tim X on 11 Dec 2009 17:33
The Magnet <art(a)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
From: Gerard H. Pille on 12 Dec 2009 07:24
Tim X schreef:
> 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
>

Did you not forget the emp-dept requirement?
First  |  Prev  | 
Pages: 1 2
Prev: VARCHAR2 Length
Next: "Business Logic / Rules should never be in the database or storedprocedures"