Is the string literal too long in Oracle?
While I try to set the value of over 4000 characters on a field that has data type CLOB, it gives me this error : ORA-01704: string literal too long. Any suggestion, which data type would be applicable for me if I have to set value of unlimited characters although for my case, it happens to be of about 15000 chars.
Is the string in ora-01704 too long?
ORA-01704: string literal too long. Any suggestion, which data type would be applicable for me if I have to set value of unlimited characters although for my case, it happens to be of about 15000 chars. Note : The long string that I am trying to store is encoded in ANSI.
How to insert into a large SQL literal?
1 Do the insert as an insert with first part is the sql literal up to 4000 chars 2 Do the additional parts as an update concatenating the previous parts with the next part where the next part is up to 4000 chars 3 Repeat step 2 until all the large sql literal is updated. Example, Insert into test_large_literal (col1, col2) values
Why did I get an error when updating a field?
While updating a field that will have more than 4000 chars, I was given a error : This worked for me when fired at Toad. Now, I created a stored procedure and compiled as :
Why is my pls-00172 string literal too long?
When i try to insert huge data into a CLOB colum, i get “PLS-00172: string literal too long”. Tried searching in web/metalink, but of no use. Please let me know if a workaround is available for this insert.
How to handle over 4000 characters in SQL?
Alex Poole is correct, the call is in an SQL context which can only handle 4000 characters. You could solve this by calling the method in a block like this: Other options include using another method to call Update_Letter_Body, creating a method to be called repeatedly to add text over 4000 characters, or using multiple input parameters.