How can i get the content of blob field?

[titi]

could I use directly ToracleQuery.sql.add('slect blob_field') to read the blob_field ?
Thanks!

 

[Marco Kalter]

You can execute a "select blob_field from table" statement in a TOracleQuery or TOracleDataSet.

For a TOracleQuery you can get the TLOBLocator instance by using the TOracleQuery.LOBField function, and subsequently use one of the TLOBLocator properties or methods to read the data.

For a TOracleDataSet you can access the field as a standard TBLOBField.