How To Call a Parameterized Stored Procedure in Oracle from a Recordset DTC (240337)
The information in this article applies to:
- Microsoft Visual InterDev 6.0
This article was previously published under Q240337 SUMMARY
This article shows how to use a Recordset Design-Time Control (DTC) to call an Oracle stored procedure, pass parameters, and retrieve recordsets.
This article assumes that you are familiar with the procedure to use ActiveX Data Objects (ADO) in an Active Server Page (ASP) page to call an Oracle package.
For more information on calling an Oracle package in ASP, see the "References" section of this article.
This article also assumes that Internet Information Server (IIS) and the development workstation are configured properly to connect to an Oracle database server. See "References" for more information on configuring IIS to connect to Oracle.
The procedure described in this article uses the PERSON table and PACKPERSON package. See "References" for instructions on their creation. You must create the PERSON table and PACKPERSON package before you use the procedure.
REFERENCESFor additional information, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
229919 How To Retrieve a Recordset from an Oracle Stored Procedure using ADO on ASP
193225 How to Configure IIS to Connect to Oracle from ASP and ADO
240338 PRB: Error Calling an Oracle Parameterized Query or Stored Procedure Using the Visual Interdev 6.0 Recordset DTC
For additional information on why you must use an Oracle Package instead of an Oracle stored procedure, click the article number below
to view the article in the Microsoft Knowledge Base:
167225 How To Access an Oracle Database Using RDO
Please see the Microsoft Universal Data Access Web site for additional information on ADO and to download the latest version of the Microsoft Data Access Components (MDAC):
For additional information on Visual InterDev, please see the following Web site:
Modification Type: | Minor | Last Reviewed: | 6/29/2004 |
---|
Keywords: | kbCtrl kbhowto kbOracle kbStoredProc KB240337 |
---|
|