Re: PL/SQL: Reading streamed data from BLOB

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 03 Dec 2002 11:54:57 +0200
Message-ID: <ashv51$j02$1@ctb-nnrp2.saix.net>

Karsten Pleines wrote:

> I am no very familiar with the Oracle PL/SQL interface. What I have to
> do is to store binary data into the Oracle database using BLOBs and to
> read this binary data from the database.

Have a look at the DBMS_LOB PL/SQL package. You can also punch this in as a keyword at http://tahiti.oracle.com

If you're using front-end software like Delphi, VB, PowerBuilder etc. - you will also find support for handling BLOBs in the client.

Delphi for example has classes for handling BLOB as memory streams.

--
Billy

Received on Tue Dec 03 2002 - 03:54:57 CST