Home » Developer & Programmer » JDeveloper, Java & XML » Inserting a String into a Clob datatype
Inserting a String into a Clob datatype [message #90879] Tue, 06 November 2001 05:24 Go to next message
Ralph Shano
Messages: 1
Registered: November 2001
Junior Member
Hi,
From the oracle documentation I thought a clob can handle up to 4 gigs of data. But if I try to insert a string into the clob datatype that is >4000 chars I get an error. Anyone have any suggestions?

----------------------------------------------------------------------
Re: Inserting a String into a Clob datatype [message #91097 is a reply to message #90879] Wed, 03 April 2002 11:17 Go to previous messageGo to next message
Senthil
Messages: 68
Registered: December 1999
Member
You should use DBMS_LOB.WRITE or DBMS_LOB.WRITEAPPEND function to write to a CLOB.
Re: Inserting a String into a Clob datatype [message #91195 is a reply to message #91097] Wed, 22 May 2002 21:18 Go to previous message
woodpeng
Messages: 1
Registered: May 2002
Junior Member
>Posted by Senthil (66.7.134.190) on April 03, 2002 at 15:17:12:
>In Reply to: Inserting a String into a Clob datatype >posted by Ralph Shano on November 06, 2001 at 09:24:54:

>You should use DBMS_LOB.WRITE or DBMS_LOB.WRITEAPPEND >function to write to a CLOB.

but I don't know how to use the DBMS_LOB.WRITE. in the procedure PROCEDURE write(lob_loc IN OUT NOCOPY BLOB,
amount IN BINARY_INTEGER,
offset IN INTEGER,
buffer IN RAW);
what do the parameters mean? can you give me a example? Thanks!
Previous Topic: ClassCastException in OraclePreparedStatement.setBlob
Next Topic: Re: execute a stored procedure from java using jdbc !
Goto Forum:
  


Current Time: Thu Aug 05 00:16:23 CDT 2021