Oracle stored procedure with table as input parameter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Oracle 10g stored procedures together with Microsoft's .Net 2.0
data provider for Oracle.

One of my functions collects data from a Windows form and passes it down to
the C# data access layer as a table in a (typed) dataset.
What I would like to do next is to pass that table into an Oracle stored
procedure, and use its contents there, i.e. not the usual requirement of
inserting/updating rows in a table.
Can I do something like creating a ref cursor IN-parameter and opening it in
the PL/SQL code?
I know I could convert the table to XML and pass that as a single string,
but I'd like to find a 'cleaner' way if possible.
 
REF CURSOR in? I believe that is only available in ODP.NET (have not tested
in .NET 2.0, however).

Other methods? XML is an option, although I am not sure I would build a
table variable from the XML as Oracle has XML methods ... unless you are not
very comfortable with XML, then pull in the XML and load the table variable
you need to work with.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top