Home » SQL & PL/SQL » SQL & PL/SQL » Unloading a BLOBs
Unloading a BLOBs [message #36029] Tue, 30 October 2001 17:48 Go to next message
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: Spooling in SQLPlus 3.3
Next Topic: date
Goto Forum:
  


Current Time: Fri Nov 22 22:22:00 CST 2024