Selecting LOB locator pointer?

[Daniel Stoch]

Hi,

Is there possible to select in TOracleDataSet BLOB (CLOB, etc.) column as a LOB locator pointer (OCILOBLocator or something like this) and store value in eg. TFloatField (not in TBlobField)? Then I will be able to use this pointer later to create a TLOBLocator (I don't know how, yet ) object and then reads its contents.

I can't use TBlobField and it is not necessary for me to fetch all BLOB's contents for each record in query.

Best regards,
Daniel Stoch

 

[Marco Kalter]

The TOracleDataSet does not allow this, but the TOracleQuery does. You can use the LOBField method to obtain the TLOBLocator instance, without actually reading any of its data.

 

[Daniel Stoch]

Hi,

I know that TOracleQuery can do this, but I need a TDataSet functionality . So I must find another solution.

Thanks for your answer.

Best regards,
Daniel Stoch