| String Size [message #69435] |
Sat, 05 January 2002 16:59  |
Tom Huang
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
|
As per the oracle database field problem i met, i tried to insert a string into a long type field, when the string size exceeds 4k, an error occurs: string literal too long! But i need to insert much longer strings into the long type field. Thanks!
|
|
|
|
| Re: String Size [message #69460 is a reply to message #69435] |
Thu, 10 January 2002 07:31  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
Hi,
This is due to mismatch of maximum-data-length between pl/sql datatype and database datatype.
DATA TYPE===== DATABASE===== PL/SQL
CHAR========== 4000=========== 32767
VARCHAR2======255 =========== 32767
LONG ========== 2GB =========== 32760
cheers
pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
