Re: ADO, OraOLEDB And Stored Procedures

Look at:

http://asktom.oracle.com/pls/ask/f?p=4950:8:153851::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:140412348065,%7Browtype%7D

HTH
Tim

"Rory Monteith" <rjmonteith_at_potashcorp.com> wrote in message news:ebeeaa46.0109271412.7db6791f_at_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 Fri Sep 28 2001 - 07:33:35 CDT