Oracle via ADODB and ODBC

Hi Maurycy,

 

I see that you've contacted the TestComplete Support Team. Let me quote their reply here:

Try using the adBSTR type.

 

Also, try connecting to your database directly using an Oracle database OLE DB provider (OraOLEDB.Oracle or msdaora). You can find sample connection strings here:

http://www.connectionstrings.com/oracle/

 

According to the below article, the VarChar2 Oracle type corresponds to the adVariant ADO type:

http://www.w3schools.com/ado/ado_datatypes.asp

 

However, adVariant is not supported by ADO:

http://msdn.microsoft.com/en-us/library/windows/desktop/ms675318.aspx

 

So, it may be possible that you will be unable to use ADO to make requests to your database. As a possible solution, you can make use of the existing .NET or Java libraries for working with the Oracle database. Information on this possibility can be found in the following help topics:

Calling Functions From .NET Assemblies 

Calling Functions From Java Classes