Home » SQL & PL/SQL » SQL & PL/SQL » Prob: help:ORA-01756: quoted string not properly terminated
Prob: help:ORA-01756: quoted string not properly terminated [message #34235] Tue, 30 November 2004 20:59 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Dear frends

I have table which has a datatype long..

table name : g_route

route_id number pk

segment_text long

when I am trying to insert into segment _text in the format of string I am getting ora01756 error.

e.g

insert into g_route values (1,'1,2,3,33,...Thisupto 5000');

It's giving error string literal too long.. is there a limit of string..

pl. give soln as early.

Bhavin

 

Report message to a moderator

Re: Prob: help:ORA-01756: quoted string not properly terminated [message #34256 is a reply to message #34235] Wed, 01 December 2004 08:51 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
A literal string in SQL is limited to 4000 characters.

Report message to a moderator

Previous Topic: 10g oracle
Next Topic: Update table1 from table2 without knowing the columns or key
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 15 12:37:02 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.