The Green Rocks trope as used in popular culture. An object or technology with powers so diverse and magical that it can cause almost any effect as needed by. Im working with an Oracle database, and I would like to read the contents of a BLOB. How do I do this When I do a simple select statement, it merely returns BLOB. Oracle database How to read a BLOB If you use the Oracle native data provider rather than the Microsoft driver then you can get at all field types. Dim cn As New Oracle. Data. Access. Client. Oracle. Connection. Dim cm As New Oracle. Data. Access. Client. Oracle. Command. Dim dr As Oracle. Data. Access. Client. Best Codec For Fax Over Voip. Oracle. Data. Reader. The connection string does not require a Provider value so you would use something like Data Sourcemy. Oracle User. IDMe Passwordsecret. Open the connection cn. LKGIzCw0/hqdefault.jpg' alt='Green Blob Games' title='Green Blob Games' />Connection. String Data Sourcemy. Oracle User. IDMe Passwordsecret. Attach the command and set the Sql statementcm. Connection cn. cm. Command. Text str. Command. Set the Fetch size. I use 4. 00. 0 because its as big as a varchar can becm. Initial. LONGFetch. Size 4. 00. 0. Start the reader and loop through the recordscolumnsdr cm. Execute. Reader. Do while dr. My. Long. String dri. You can be more specific with the read, eg dr. Get. Oracle. Stringi dr. Get. Oracle. Clobi etc. If youre reading a LONG datatype then the simple dri or dr. Get. Oracle. Stringi works fine. The key is to ensure that the Initial. LONGFetch. Size is big enough for the datatype. Note also that the native driver does not support Command. Behavior. Sequential. Access for the data reader but you dont need it and also, the LONG field does not even have to be the last field in the select statement.