Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ADO, OraOLEDB And Stored Procedures

ADO, OraOLEDB And Stored Procedures

From: Rory Monteith <rjmonteith_at_potashcorp.com>
Date: 27 Sep 2001 15:12:21 -0700
Message-ID: <ebeeaa46.0109271412.7db6791f@posting.google.com>


I am currently working on an integration project for an installation of Oracle Applications (OPM module). In our approach, we would like to use Visual Basic 6.0/ADO 2.6 to call the OPM API's.

The question I have, is how can I call a stored procedure that has a recordset as an input parameter. The API I wish to call has a header that looks like this, and the parameter that is causing me trouble is (p_item_rec):

GMIPAPI.Create_Item

( p_api_version        IN  NUMBER

, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
, p_commit IN VARCHAR2 := FND_API.G_FALSE
, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
, p_item_rec IN GMIGAPI.item_rec_type
, x_ic_item_mst_row OUT ic_item_mst%ROWTYPE
, x_ic_item_cpg_row OUT ic_item_cpg%ROWTYPE
, x_return_status OUT VARCHAR2
, x_msg_count OUT NUMBER
, x_msg_data OUT VARCHAR2
); I have been unable to find any documentation on this, and any help that you could lend would be greatly appreciated. Thanks, Rory Monteith Programmer
Received on Thu Sep 27 2001 - 17:12:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US