Passing datatable from C# to Oracle.

I have already posted a similar message earlier and but posting again for this specific requirement.

I have a C# application which uses ODBC.net(System.Data.OracleClient) to insert records in oracle database. In order to improve performance of our system, I need to use FORALL bulk insert option provided by Oracle.
I have written a stored procedure which will accept table object defined in the Proc.
I don't know how to pass a .Net DataTable from C# application to the oracle stored procedure.

Here is the sample.

create or replace package BookAlloc_Pck is

• Declare objects having structure of the table record type TYPE Alloc_Details_t is TABLE OF AllocationDetails%ROWTYPE INDEX BY BINARY_INTEGER; PROCEDURE prc_load_alloc_records(Alloc_in IN Alloc_Details_t); end BookAlloc_Pck;

create or replace package body BookAlloc_Pck is procedure prc_load_alloc_records(Alloc_in IN Alloc_Details_t) is begin

        forall i in 1.. Alloc_in.count

                insert into allocationdetails values Alloc_in(i);                         

                commit;

end prc_load_alloc_records;
end BookAlloc_Pck;

Thanks Received on Thu Sep 28 2006 - 04:55:12 CDT