I am using the Oracle OLEDB provider and need to set the
PLSQLRSet property to 1 to return a rowset. If I add this
property to the connection string it works OK but the
Oracle documentation says don't do that, use a command
object property instead. It then gives a VB example of how
to do this, ie...
objCmd.Properties("PLSQLRSet") = TRUE.
BUT I am using VC++ and ADO smart pointers so how do I set
a command property?
I assume I need to create a new property and add it to the
properties collection, but the methods exposed by
_PropertiesPtr and _PropertyPtr, do not seem (to me
anyway!) to provide enough functionality to create a named
property and add it to a collection.
If you have done this, please advise.