HI,
I am using Oracle 7 to insert an Access database rows using ADO. I created an Oracle Stored procedure that accepts parameters and insert them into the Oracle table.

In VB, I created a command object and added parameters to it. Then, I simply iterate through the Access recordset and I refresh the command object parameters. The command object command type is adStoreProc and the command text is the name of my Oracle stored procedure.

At each iterations of the Access recordset, I refresh my command parameters and I execute the command. In Oracle 7 this works fine (slow but fine). I am wondering if it is going to be the same process in Oracle 8. I know that Oracle 8 has a native Ole DB provider. But I saw that we can use OO4O. Do I need to use it ?

Thank you,
Christian Cote