'Note that this code fragment assumes a ORABFILE object as the result of a 'dynaset operation. This object could have been an OUT parameter of a PL/SQL 'procedure. For more information please refer to chapter 1.
Dim OraDyn as OraDynaset, OraDyn2 as OraDynaset, OraPhoto as OraBFile 
Dim OraImage as OraBlob

chunksize = 32768
Set OraDyn = OraDb.CreateDynaset("select * from Multimedia_tab", ORADYN_DEFAULT)

Set OraPhoto = OraDyn.Fields("Photo").value
Set OraFrame = OraDyn.Fields("Frame").value

OraDyn.Edit
'Load LOB with data from BFILE: 
OraFrame.CopyFromBFile (OraPhoto)
OraDyn.Update
