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

From: Vish <vishalk7_at_gmail.com>
Date: 20 Sep 2006 23:47:31 -0700
Message-ID: <1158821251.855939.326400@i3g2000cwc.googlegroups.com>

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 Received on Thu Sep 21 2006 - 01:47:31 CDT