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

    data type clob

      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 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.

      How to Fix this issue

      Anyone Please help me its urgent.

      Thanks & Regards,