BLOB field problems. Help!!!

[bloughead]

Some background info.

Have a 3-tier Delphi 7 application with Oracle 9i as the database.

Have previously been using DOA 3.4.6 and had no problems updating BLOB fields and also deleting records with BLOB fields.

I am currently testing our application with the new DOA 4.0, but when I go to modify an existing BLOB field or deleting one I get the Delphi reconcillation box that says that the record has been modified by someone else eventhough I'm the only one doing anything with it.

Now I know that you have updated your BLOB fields to be temporary during Post events then if so how do I fix our source code or is there a setting that will allow the 4.0 to act the same as the 3.4.6.

Thanks in advance for any help that can be provided.

Brian Loughead

 

[Marco Kalter]

This seems like a bug to me. We'll look into this.

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

 

[hoefmanm]

Had the same problem with pl/sql developer as we changed Database from 8.1.7.4 to 9.2.0.2. In some cases we couldn't access LOB Fields. (e.g. SELECT LOBFIELD FROM TABLE@DATABASELINK). We thought that it was an incompability with the new oranetdrivers (8i / 9i).

If you are using the 8i Client with a 9i database you are not able do access LOB fields in some cases. Try to install then 9i client and then it should work.

 

[bloughead]

Thanks for the info but I have 9i client installed with 9i Oracle.

Anyways we can access the BLOB field for the record, its when we want to manipulate a record with a BLOB field with existing data.