Re: [Squirrel-sql-users] CLOB length greater than 4001

[Maury H. <ml1...@sh...>]

Tony:

> When trying to insert a CLOB with a length greater than 4001 I get the following error:
> 
> Error: java.sql.SQLException: ORA-01704: string literal too long
> 
> OS W2K
> SQuirreL SQL 1.2beta6
> Oracle Plugin 0.13
> JDK 1.4.1_05
> Oracle Thin Driver version 9.2.0.3.0
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production (Solaris 9)
> 
> Does anybody know if this is an issue with Oracle or Squirrel SQL?

It is an Oracle issue.  Go to otn.oracle.com and get the 10g JDBC driver.  I 
haven't done a lot of testing with it, but I have seen comments on the net 
that Oracle has fixed a number of problems with C/BLOBS in that version of 
the driver.


Maury...