Home » RDBMS Server » Server Administration » need help on inserting data into a long datatype
need help on inserting data into a long datatype [message #370266] Thu, 15 July 1999 18:43
Way
Messages: 1
Registered: July 1999
Junior Member
Could anyone help me on this, please.
I have trouble inserting data into a long datatype. Suppose it can hold up to 2GB of characters. However,
I can only insert up to 4K of characters. If the characters is more than 4K, it gives me an error: "ORA-01704: string literal too long". For example,
there is a table:
type
(
text long
)

what I did was just:
insert into type values('aaaaaaaaa...')
and it returns me an error.
Could anyone tell me how I should insert data into a long datatype if the string is longer than 4K,please?
Thanks a lot.
Previous Topic: Re: To_Date Function
Next Topic: Reg:Index
Goto Forum:
  


Current Time: Fri Oct 23 17:25:10 CDT 2020