Help with OLEDB Parameters & ORACLE REF CURSOR (MS Data Provider)

12 Jan 2007 2:04 PM

Philip

Hi,

I am building an application that will retrieve a list of stored procedures
for a schema, with their parameters. This is basically to enable us to test
the stored procedures and performance.

First I query the ORACLE database 'user_arguments' table to get a list of
stored procedures and all the parameters with data types and position. The
stored procedures populate a combo box.

The user selects a stored procedure and the params to be filled will
populate a datagrid.

After the user has entered the values for the parameters of the selected
stored procedure, I want to execute the stored proc (which will always return
a REF CURSOR) and populate a data grid with the returned data.

We are using the MS Data Provider for Oracle.

Using that provider, how do I get the result of the stored proc into a
dataset please so I can populate a datagrid?

thanks

Philip

12 Jan 2007 6:23 PM

Paul Clement

On Fri, 12 Jan 2007 06:04:02 -0800, Philip <Phi***@discussions.microsoft.com> wrote:

¤ Hi,
¤
¤ I am building an application that will retrieve a list of stored procedures
¤ for a schema, with their parameters. This is basically to enable us to test
¤ the stored procedures and performance.
¤
¤ First I query the ORACLE database 'user_arguments' table to get a list of
¤ stored procedures and all the parameters with data types and position. The
¤ stored procedures populate a combo box.
¤
¤ The user selects a stored procedure and the params to be filled will
¤ populate a datagrid.
¤
¤ After the user has entered the values for the parameters of the selected
¤ stored procedure, I want to execute the stored proc (which will always return
¤ a REF CURSOR) and populate a data grid with the returned data.
¤
¤ We are using the MS Data Provider for Oracle.
¤
¤ Using that provider, how do I get the result of the stored proc into a
¤ dataset please so I can populate a datagrid?

See if the following helps:

http://msdn2.microsoft.com/en-us/library/bw9eczdk.aspx

Paul
~~~~
Microsoft MVP (Visual Basic)