Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ADO, OraOLEDB And Stored Procedures
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 NUMBERReceived on Thu Sep 27 2001 - 17:12:21 CDT
, 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
![]() |
![]() |