OraFAQ Forum: Server Administration » LONG type problem

Home » RDBMS Server » Server Administration » LONG type problem - ORA-01704: string literal too long

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LONG type problem - ORA-01704: string literal too long [message #373220]

Wed, 04 April 2001 13:59

Paul
Messages: 164
Registered: April 1999

Senior Member

Hi, I created a table with a LONG type. From what I read in the Oracle docs LONG supports up to 2 gigs of data. But I am not able to insert more than 4000 characters into that field.

I am new to SQL/ORACLE and any help would be nice.

Report message to a moderator

Re: LONG type problem - ORA-01704: string literal too long [message #373221 is a reply to message #373220]

Wed, 04 April 2001 14:06

Paul
Messages: 164
Registered: April 1999

Senior Member

Oh, I am using Oracle 8.0.5 and I'm using SQL worksheet to insert my data.

Report message to a moderator

Re: LONG type problem - ORA-01704: string literal too long [message #374360 is a reply to message #373220]

Thu, 07 June 2001 15:33

Ranganadha
Messages: 1
Registered: June 2001

Junior Member

I created table with long field. But I am unable to store more than 2 pages of text. Could you help me. Thanks.

Report message to a moderator

Previous Topic:	upper
Next Topic:	Synonm Creation Script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 13:06:33 CDT 2024