Re: Passing collection of records to PL-SQL from C# Application

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 21 Sep 2006 01:07:42 -0700
Message-ID: <1158826062.674445.198090@k70g2000cwa.googlegroups.com>

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 - 03:07:42 CDT