Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Passing collection of records to PL-SQL from C# Application
Hi,
Many Thanks for the URL.
Could you suggest any other option apart from this one ?
regards,
Vishal
Vladimir M. Zakharychev wrote:
> Vish wrote:
> > Hi,
> > I am trying to use "FORALL" for bulk insertion into an oracle table
> > because of performance bottleneck.My application is in C#.
> >
> > "FORALL" supports insertion only through collections (eg. nested tables
> > or varrays or Indexed tables).
> > My application is receiving data from a data grid(User Input) which
> > needs to be inserted into the table but I could not find any way
> > through which I could pass those input values to the collections
> > supported by PL-SQL.
> >
> > I have found an article for the same but that's for Java.
> > http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:712625135727
> >
> > Thanks,
> > Vishal
>
> http://download-uk.oracle.com/docs/html/B28089_01/featOraCommand.htm#BABBDHBB
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Received on Thu Sep 21 2006 - 04:24:22 CDT