Recent content by grahamr

Fixed it. I needed to have cast the result of a GetComplexVariable to a TLOBLocator like so: Which now works. ------------------ -- Graham Reeds,http://omnieng.co.uk | grahamr@omnieng.co.uk

Found something out: If you run it again (ie start the process manually without exiting the program) it works fine. This suggests that there is something wrong with the TLOBLocator.

Also before you mention it the ampersand in the final line of my code is a by-product of my clutching-at-straws style of code development. I've also tried starting the count from 1 and increasing the size of the buffer.

The code of the Query: The code of the unit: Hope you can make sense of that code (cos I can't:-) ------------------ -- Graham Reeds,http://omnieng.co.uk | grahamr@omnieng.co.uk

Hi, I'm trying to retrieve a BLOB from an Oracle9i server. When ever I try to retrive the BLOB it fails with an Invalid handle message. However inspecting the length returned from the PLSQL function returns the correct size, while using the ->Size property fails (Invalid Handle). The only two...