Re: Stored Procedure INSERT from VB.NET application

Ok, thanks for your tip :)

Runar

"tojo" <Tojo_at_hotmail.com> wrote in message news: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
> xml document and send it to your procedure as a CLOB (to reduce IN
> parameters).
>
> -- Tom
Received on Tue Feb 25 2003 - 18:44:11 CET