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_at_bignews5.bellsouth.net>
Date: Sun, 19 Oct 2003 23:23:14 -0500
Message-ID: <ToJkb.25443$5n.24400_at_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...Received on Mon Oct 20 2003 - 06:23:14 CEST
> 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