| Inserting a String into a Clob datatype [message #90879] |
Tue, 06 November 2001 05:24  |
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 #91195 is a reply to message #91097] |
Wed, 22 May 2002 21:18  |
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
