da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: BLOB's and DataSet on Oracle 8i

Forum List » NCOCI8 » General English

Junior
User

Fresh Boarder

Posts: 2

Karma: 0

BLOB's and DataSet on Oracle 8i

Posted: 2000/08/23 23:26

How can I work with Blob field's using OCIQuery.ReadOnly = False ?

When I'am use OCIQuery with ReadOnly = False,
and execute OCIQuery.Post, a message error is return: ORA-22292 Cannot open a LOB in read-write mode without a transaction.

Please, Help-me !!!, What is solution ?

PS.: Congratulations your NCOCI8 component's is excellent !!!

Diman

Admin

Posts: 1495

Karma: 19

RE: BLOB's and DataSet on Oracle 8i

Posted: 2000/08/24 09:14

Hi Junior !

Right now TOCIQuery works properly only if you read BLOB's. If you want to edit field of type BLOB - i am sorry, but this feature does not work. You should work with BLOB fields manually. I sended directly to your email demo project, that demonstrate such technique. I will include this demo into next NCOCI8 release.

About error ... If you will work with BLOB manually, the error will exist so. This mean, that before BLOB modification, you must start transaction, lock row with BLOB (SELECT FOR UPDATE). After that you can modify BLOB. Also, it will be good to read Oracle documentation

Forum List » NCOCI8 » General English