VB6 Oracle Retrieving Clob into an array -

Without improve retrieval SQL string I am trying to retrieve VB array with Kolb type the Oracle field Detaat I am (just SELECT * FROM my table). I am using an ADO record set.

When I close the connection or do any other work with the record set, then the clab values ​​are lost. How can I get it?

try to manipulate the blob and Sielo using I ADO in my project, but without If you do not switch to any success, you need to install and configure Oracle Client on your machine, add "Oracle Inprac Server 4.0 Type Library" in the project context.

Here is a sample code that I used for BLOB:

  OracleInProcServer.OraSessionClass as dim Oraasn Dim OraDatabase OracleInProcServer.OraDatabase OracleInProcServer as dim OraDynaset OraBlob set as .OraDynaset Dim srcImg OraSession = CreateObject ( "OracleInProcServer.XOraSession") OraDatabase = OraSession.DbOpenDatabase set ( "myDBName", "login / password", 0 & amp;) OraDynaset = OraDatabase.DbCreateDynaset ( "SELECT src_id, in src_image set of sources, where src_file_name '% .png', such as 0 and amp;) If the Oradinaset Kkrarkard & gt; 0 then. Mwwfst (though. O F or .afof) is set srcImg = Kfrens ( "src_image"). Value srcImg.CopyToFile ( "C: \ sources \" and srcID and ".png") .MoveNext Wend End If End With Oradinset set = Set Nothing OraDatabase = None Set Ora Session = Anything