Re: Storing Blobs or BFiles in Black Box Storage Device

acebgur_at_yahoo.com (acebgur) wrote in message news:<43292cf8.0404110357.4cf8c11d_at_posting.google.com>...
> Hi-
>
> Has anyone had experience configuring an Oracle DB to store blobs or
> BFiles to an object based device? It seems as though by default blobs
> get stored inline in the database. And BFiles are required to be
> managed outside of the database, but must reside in an accessible file
> system. What it someone wanted to put this data in a "Black Box" that
> was only accessible via an API? Where would they place the Oracle
> "hooks" to this data?
>
> Thanks-
> Ace
>
> http://groups.yahoo.com/group/CenteraTechGroup/

Never done it, never heard of it. So here is my guess. You could create a Oracle Procedure whose source is either PL/SQL, C, or Java that interfaces with your external system. For instance, if you did it with PL/SQL code, perhaps you could use the Oracle supplied UTL_TCP package and open a socket to talk with the other system. Or perhaps the external system provides a java API you can utilize.

So your code might be something like....

PROCEDURE INSERT_BLOB(P_ID in NUMBER, P_BLOB in BLOB); FUNCTION GET_BLOB(P_IN in NUMBER) RETURNS BLOB;

Dave Received on Mon Apr 12 2004 - 08:43:01 CDT