Re: ADO.NET and PL/SQL tables

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Sun, 19 Oct 2003 23:23:14 -0500
Message-ID: <ToJkb.25443$5n.24400@bignews5.bellsouth.net>

Wouldn't the 9iR2 table functions capability help in this case? They can take in rows and put out rows.

See the docs on this new feature at. There are some good examples in the docs too.

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/08_subs.htm#19700

-- 
"Vikas Agnihotri" <fornewsgroups_at_vikas.mailshell.com> wrote in message
news:oprw330tbp3k814u_at_news.fu-berlin.de...


> Is it possible for a ADO.NET (.NET framework 1.0) application to pass

> simple one-dimensional PL/SQl tables as IN parameters to a Oracle stored

> procedure?

>

> I would have thought this is simple by now, but from what I tried I just

> cant get it to work.

>

> I know there are some third party (DataDirect) drivers that support this,

> but I would like to get it working using plain .NET's provider.

>

> Help? Thanks

Received on Sun Oct 19 2003 - 23:23:14 CDT