Problem with TOracleQuery.FieldAsString and blobs

[Greg Stevenson]

Running a TOracleQuery that returns a blob using FieldAsString returns a string of the correct length but it is all nulls. Same query in a PL/SQL SQL window and the Data Editor shows the correct info. TOracleDataset also seems to get it right. Tried variants, GetLongField, FieldData with similar results. Any suggestions? Its like its alocating space but not triggering the separate fetch even though Clobs seem to be fine.

DOA 4.x
PL/SQL Developer
Version 7.0.0.1050 (MBCS)
Using
Home: OraClient10g_home3
DLL: C:\Oracle\product\10.1.0\Client_3\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.5.0
Character size: 1 byte(s)

--Greg

 

[Marco Kalter]

What happens if you access the TLOBLocator (LOBField) and use the AsString property?

 

[Greg Stevenson]

The LOBField does seem to work so I can us that. But it seems that if CLOBs work with AsString (or FieldAsString) that BLOBS should as well. In anycase, I can keep working on this project now so thanks.
--Greg