Re: Stored Procedure INSERT from VB.NET application
From: tojo <Tojo_at_hotmail.com>
Date: Tue, 25 Feb 2003 18:22:32 +0100
Message-ID: <MPG.18c5c4c317d45e049896f7_at_news.t-online.de>
Date: Tue, 25 Feb 2003 18:22:32 +0100
Message-ID: <MPG.18c5c4c317d45e049896f7_at_news.t-online.de>
In article <8zL6a.31835$Rc7.451171_at_news2.e.nsc.no>, runaremg_at_online.no
says...
> I want to supply all columns of my database row as arguments to an Oracle
> Stored Procedure without using numerous IN parameters. The procedure look
> something like:
>
> create procedure my_proc(my_row my_table%rowtype) is ...
>
> I'm using Oracle 8.1.7, ODPNET 9.2 and VB.NET 1.0. How can I achieve this
> functionality ? All tips appreciated!
>
>
>
ODP.NET doesn't support %rowtype. You could wrap up the columns in an
[Quoted] xml document and send it to your procedure as a CLOB (to reduce IN
parameters).
- Tom