how to set a property of PLSQLRSet on OleDb.OleDbCommand
632601Apr 7 2008 — edited Apr 22 2008I am using OraOLEDB.Oracle provider. I need to return resultset from stored procedure/package (Oracle 9.2). The only sample that I found for
System.Data.OleDb is using PLSQLRSet set on a connection of System.Data.OleDb.OleDbConnection
and using CommandText = "{call PRODUCTS.GETPRODUCTSINFO(?,?)}"
In the VB6 sample author mentioned that you shouldn't set this on a connection, that it should be on a command instead and gave an example. I don't see that property System.Data.OleDb.OleDbCommand. Why this property cannot be on a connection? Why does it need to be reset after the call is done. If I have multiple connection string then connection pooling will not be used, right?