MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Oracle


 

Command Syntax

The OLE DB Provider for Oracle recognizes command syntax specified by the DBGUID_DBSQL macro. This provider does not support the {result set} escape in the ODBC Driver.

Stored Procedures

When executing an Oracle stored procedure using a command, you can use the ODBC procedure call escape sequence in the command text.

ODBC SQL Syntax

{call CREDIT_TO_ACCOUNT(123456, 100.00)}

Oracle PL/SQL Syntax

BEGIN 
   CREDIT_TO_ACCCOUNT(123456, 100.00);
END

Note   CURSOR REF is not supported.