As of Oracle 8, Oracle mandates that in order to write data to a LOB datatype ( Blobs and Clobs are subtypes of the LOB type) that you must be in a transaction. this is due to the

changes in the way oracle implemented the LOB data type. To get around this issue start a

transaction before you attempt to write data to a LOB data type.

for example if your code was (Delphi example)

Table .Insert; Table KEYFLD.AsInteger := new_val; Table TESTFLD.LoadFromFile('D:\data\test.bmp'); Table .Post; change it to

Database .StartTransaction; Table .Insert; Table KEYFLD.AsInteger := new_val; Table TESTFLD.LoadFromFile('D:\data\test.bmp'); Table .Post; Database .Commit;

and this will get you around the issue. For more information on LOB data types see the Oracle 8 documentation.

3/26/99 0:5 :08 AM