BLOB field not working in REF CURSOR

[kan_hk]

Hello,

I'm using Delphi 5, DOA 3.4.6.1, and Oracle 8.1.7.4.1 to develop an application. I also wrote a package to encapsulate a table with the following structure:
CREATE TABLE ATABLE (
AID NUMBER NOT NULL PRIMARY KEY,
AOBJECT BLOB
) ;
The package returns the ref cursor ATABLE%ROWTYPE to the Delphi application. It seemed okay when I loaded a word file into the BLOB field; however, when I restarted the application, the previous word file was not saved into ATABLE. I checked the physical ATABLE and found the BLOB field empty.

So I'd like to know if there is any limitation in using package to return the result set cursor? If so, how to solve it?

Thank you very much in advance.

Regards,
Kan

 

[Marco Kalter]

This should work just fine. Can you show me the Delphi code that writes the data to the BLOB column?

------------------
Marco Kalter
Allround Automations