Posting BLOB data in Midas

[DelphiGreg]

Hi Folks,

Working with a n-tier midas app that does minor things with graphics. In the client app, the user can view, load or save images from a Oracle database. The Oracle field containing the data is type BLOB, the TFields are TBlobFields.

Doing this in two-tier works fine. When moving things into the appServer though, I continually get a message "ORA-01461: can bind a LONG value only for insert into a LONG column". Watching things in debug mode I think what is happening is somewhere the data is being typecast as Long Raw. This would indeed produce this error.

Any ideas how to make this work?

Thanks,

Greg Postlewait

 

[Marco Kalter]

In Delphi 5 this problem is probably caused by the TDataSetProvider.ResolveToDataSet property. When it is set to True, updates are applied directly through SQL statements and are not applied through the related dataset. For Oracle8 CLOB and BLOB fields this goes wrong when ResolveToDataSet = False, as it simply fires a statement to update the LOB data as if they were normal columns. We hope to work around this problem in the next patch release.

What happens if you set ResolveToDataSet to True for this DataSet?

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