Oracle package Blob Delphi

[Erasmus]

We try to build a Delphi program to fill a database with pictures. There is an oracle package available to do this. We use oracle version 8.0.6. When we try to create an TLobLocator instance with TLOBLocator.CreateTemporary we get an error message: 'EOracleError with message ""'. When we use TLOBLocator.Create we get no error message, but when we try to load the picture with the procedure LoadFormFile we get the error message 'invalid File handle'.

Any ideas?
Hans

 

[Marco Kalter]

Temporary LOB's are new in Oracle 8.1, so 8.0.6 does not support it. You will have to use a standard LOB instead, created through TLOBLocator.Create.

However, in that case you must first insert an empty_blob() into the database, return the (empty) LOB locator into your TLOBLocator instance, and then call LoadFromFile. See this topic for additional info.