Unloading a BLOBs [message #36029] |
Tue, 30 October 2001 17:48 |
RJ Heibel
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
I have gotten the hang of loading BLOBS and CLOBS in Oracle 8. I have even unloaded CLOBS by using DBMS_LOB and UTL_FILE packages. However, I have not been able to figure out a way to unload BLOBS with PL/SQL 8 to an OS file successfully. Has anyone ever successfully unloaded a BLOB in Oracle 8 through PL/SQL,JDBC,ODBC, or OCI successfully to an OS file?
Thanks in advance,
RJ
----------------------------------------------------------------------
|
|
|
Re: Unloading a BLOBs [message #36039 is a reply to message #36029] |
Wed, 31 October 2001 07:36 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
You'll need to use either a C-based external procedure or a Java stored procedure to accomplish this.
----------------------------------------------------------------------
|
|
|