This discussion is archived
0 Replies Latest reply: Sep 12, 2012 8:15 AM by 961699 RSS

oraOLEDB and Associative Array as OUT parameter of a Stored Procedure

961699 Newbie
Currently Being Moderated
Hi,

We have a Stored Procedure which has an OUT parameter of type Associative Array of VARCHAR2. We have a .NET application which connects to the database using MSDAORA provider and executes this procedure using ODBC call syntax - {call <<proc>>(params..., {resultset 2000, param_out})}.

As MSDAORA provider is not supported we want to move over to a different provider with minimal code changes. Using ODP.Net would mean lot of code changes so we would like to use oraOLEDB provider instead. However this provider does not support the "resultset" syntax. Does oraOLEDB support working with Stored procedures that have associative array as OUT parameter?

We tried removing the "resultset" syntax and followed the suggested syntax for using ref cursor as out parameter but it does not work. Is there a way to work with Associative Arrays using oraOLEDB provider?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points