accessing Oracle BLOB fields with ADO
I'm having problems using ADO to access a BLOB field in an Oracle database.
Did any body face the same problem or have any way arround it? any smart
Re: accessing Oracle BLOB fields with ADO
"IHAQ" <firstname.lastname@example.org> wrote:
>I'm having problems using ADO to access a BLOB field in an Oracle database.
>Did any body face the same problem or have any way arround it? any smart
The problems that you may encounter with BLOB fields include:
1. Can not be read by the Microsoft Provider - ONLY the Oracle Provider
2. You must write GETCHUNK code to retrieve the BLOB data - there is no
simple, direct reference to read BLOB fields.
We have not been successful reading BLOB using ADO. The best method appears
to be to create an object connection, retrieve with an SQL statement, and
maually load BLOB to a variable.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center