gnosys
Oct 5th, 2000, 09:31 AM
Fellow Programmers,
Does anyone know how to pass an ADO recordset as an input parameter to an Oracle stored procedure? Is it even possible? I'm using ADO 2.5's Oracle OLE DB provider (MSDAORA). I've got my table-type defined in the Oracle package spec to match the structure of my recordset, but when I execute the command, I get a message to the effect that the provider does not support arguments of the TABLE or RECORD type. Maybe this is true, but since you can return a recordset FROM an Oracle stored procedure, I thought I should be able to pass one TO an Oracle stored procedure as well. Any light that you can shed upon this topic would be mucho appreciated. TIA.
G.
Does anyone know how to pass an ADO recordset as an input parameter to an Oracle stored procedure? Is it even possible? I'm using ADO 2.5's Oracle OLE DB provider (MSDAORA). I've got my table-type defined in the Oracle package spec to match the structure of my recordset, but when I execute the command, I get a message to the effect that the provider does not support arguments of the TABLE or RECORD type. Maybe this is true, but since you can return a recordset FROM an Oracle stored procedure, I thought I should be able to pass one TO an Oracle stored procedure as well. Any light that you can shed upon this topic would be mucho appreciated. TIA.
G.