Home » RDBMS Server » Server Utilities » String Size
String Size [message #69435] Sat, 05 January 2002 16:59 Go to next message
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 Go to previous message
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
Previous Topic: Re: FREE OCP PAPERS
Next Topic: Re: OCP Exam
Goto Forum:
  


Current Time: Wed Feb 21 05:01:03 CST 2024