SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Receive TYPE ARRAY as input from ADO.NET or C#

Ranganathan VenkatesanAug 3 2016 — edited Aug 4 2016

Hi All,

The front end application in my project is using ADO.NET and C# code.

We have a requirement were in users will upload a Excel file with 5000 rows and front end has to send it in a COLLECTION to Oracle Stored Procedure.

Currently they are passing row by row to insert into a table.

I am from Oracle background and I know how to handle TYPE Array as INPUT in Procedure and insert into table using BULK COLLECT.

I need help on how can ADO.NET or C# code be used to pass the data from Excel as a TYPE ARRAY input to Stored Procedures.

Please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 1 2016

Added on Aug 3 2016

4 comments

798 views