| String literal too long [message #371600] |
Sun, 12 November 2000 12:09  |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
|
I'm getting the error ORA-01704 which says String literal too long when I'm using the update statement to update a field with datatype set to LONG. How to overcome this problem. Someone please reply imdtly...
|
|
|
|
| Re: String literal too long [message #371655 is a reply to message #371600] |
Mon, 20 November 2000 13:54  |
John Dorlon
Messages: 3
Registered: November 2000
|
Junior Member |
|
|
Instead of this :
'really long string literal, blah, blah, blah'
Try this :
'really long ' || 'string literal ' || 'blah blah blah'
I have never had this error in PL/SQL development but I have seen it in other programming languages and this is how I get around it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
