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>


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
Received on Tue Feb 25 2003 - 18:22:32 CET

Original text of this message