Why setClob() and setBlob()?

From: Julien Reynier <julien.reynier_at_free.fr>
Date: Wed, 28 Feb 2001 23:25:43 GMT
Message-ID: <3A9D8765.948EE3ED@free.fr>

Hi,

After reading "Working with BLOBs and CLOBs" in "Oracle8i JDBC Developer's Guide and Reference Release 2 (8.1.6)" <http://oradoc.photo.net/ora816/java.816/a81354/oralob2.htm#1043220> I understand that you can't create or populate a BLOB or CLOB column and that you have to use them with a locator.

So I see the use of getBlob() and getClob() methode to get CLOB or BLOB locator but I don't see setBlob() and setClob() use due to the fact that you update a CLOB or BLOB data by getting its locator and by writing data in as in this Oracle example:
...

writer = ((CLOB)my_clob).getCharacterOutputStream();

writer.write(data);
writer.flush();
writer.close();

...

No setXXX() methode is necessary!!!

Maybe I missunderstood the use of setClob() and setBlob()... Is there anybody to help me?

Julien Reynier Received on Wed Feb 28 2001 - 17:25:43 CST