Error : ORA-01704: string literal too long

by

What are you using when operate with CLOB?

In all events you can do it with PL/SQL

DECLARE
  str varchar2(32767);
BEGIN
  str := 'Very-very-...-very-very-very-very-very-very long string value';
  update t1 set col1 = str;
END;
/

Proof link on SQLFiddle

More Related Contents:

  1. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  2. How do I escape a reserved word in Oracle?
  3. How to put more than 1000 values into an Oracle IN clause [duplicate]
  4. ORA-30926: unable to get a stable set of rows in the source tables
  5. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  6. Fetch Oracle table type from stored procedure using JDBC
  7. “Safe” TO_NUMBER()
  8. When or Why to use a “SET DEFINE OFF” in Oracle Database
  9. error: ORA-65096: invalid common user or role name in oracle
  10. Oracle insert if not exists statement
  11. Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL
  12. Oracle JDBC and Oracle CHAR data type
  13. Does Oracle have an equivalent of SQL Server’s table variables?
  14. Reason why oracle is case sensitive?
  15. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  16. Oracle date difference to get number of years
  17. SQL Fiddle Output Error
  18. oracle PL/SQL how to calculate range ip for IPv6 cidr
  19. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  20. Oracle: how to add minutes to a timestamp?
  21. How to drop multiple interval partitions based on date?
  22. How to list active / open connections in Oracle?
  23. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  24. merge update oracle unable to get a stable set of rows
  25. How to get the week day name from a date?
  26. DBMS_JOB vs DBMS_SCHEDULER
  27. Java: How to insert CLOB into oracle database
  28. How to change default nls_date_format for oracle jdbc client
  29. How to generate a GUID in Oracle?
  30. Escaping single quote in PLSQL

Leave a Comment