How to store file and load from Oracle 9i.

[rakgol_a]

Hi, (Delphi7,Oracle 8i,9i; DOA4)

I'm looking for a HOW-TO to store, update and
retrieve any file from the database.
I assume table structure might look like this
(filename varchar2(255), DBFILE BLOB)

Thanks in advance

 

[Marco Kalter]

If you create a TOracleDataSet to access this table, then you can manipulate the BLOB contents through a standard TBLOBField.

If you are using a TOracleQuery you can do low-level selects, inserts and updates on the BLOB by using the TOracleQuery.LOBField function and the various TLOBLocator functions. See the TLOBLocator topic in the help file for more information.