| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
