1 Reply Latest reply: Mar 14, 2013 1:20 PM by Jean-Pierre Dijcks RSS

    data type clob

    979147
      Hi,
      i am using one table t1, column1 clob null, i will insert the data the data maximum size(6000 character) not inserted the data.



      ERROR:


      Error starting at line 2 in command:

      Error at Command Line:2 Column:98
      Error report:
      SQL Error: ORA-01704: string literal too long
      01704. 00000 - "string literal too long"
      *Cause:    The string literal is longer than 4000 characters.
      *Action:   Use a string literal of at most 4000 characters.
      Longer values may only be entered using bind variables.
      commited.

      How to Fix this issue

      Anyone Please help me its urgent.

      Thanks & Regards,

      Saran