Passing a VB ADO 2.6 recordset to PL/SQL [message #37237] |
Fri, 25 January 2002 12:33 |
Darryl
Messages: 2 Registered: January 2002
|
Junior Member |
|
|
Is it possible to pass a VB ADO 2.6 recordset as a prameter to a pl/sql package?
My package is set up with an sproc that has one input parameter that is defined as a table of rowtype matching the table that I will be loading the recordset to. The number of fields in the recordset and the table are the same, I am just discarding the ID field from the recordset.
Please e-mail if you need to see the code.
Thanks in advance,
Darryl
|
|
|
|
Re: Passing a VB ADO 2.6 recordset to PL/SQL [message #37259 is a reply to message #37237] |
Mon, 28 January 2002 07:16 |
Darryl
Messages: 2 Registered: January 2002
|
Junior Member |
|
|
thanks pratap,
I have tried my code and I get an Oracle error about the parameters being out of range. I did not write down the error message but I will re-run the code today and get the actual message.
I have tried several different ADO types to pass the recordset parameter, but they all get the same error message back from Oracle.
I also plan on converting the recordset to an array to see if this helps, although on large batch updates I think it would cause problems.
regards,
darryl
|
|
|
|