Recent content by Jarle

  1. J

    ORA-22290 BFile/LOB problem

    This actually seems to make the problem worse, because (AFAICT) then one file gets "leaked" for each row in the resultset containing a LOB. (I initially assumed the last LOB in the resultset got leaked, but now it seems to me that it is the last one in the "group" of records fetched which gets...
  2. J

    ORA-22290 BFile/LOB problem

    Getbfile() is a method of an ORDIMAGE (ORDSYS.ORDIMAGE) object to get the image content if the image data is stored in a BFile. If the image data is stored in the row itself (BLOB), the corresponding call to get the data is GetContent(), and in that situation there is no problem. By searching...
  3. J

    ORA-22290 BFile/LOB problem

    We use a query like this: SELECT t1.thumbnail.Getbfile() thumbnail, title from sometable t1 where somefield=5 as a datasource for a (DevExpress) grid to display a thumbnail image and some other info for each row. The OracleMonitor shows that for each row with a thumbnail, the LOB is opened and...
Back
Top