array of oracleparamters

  • Thread starter Thread starter Venkat Chellam
  • Start date Start date
V

Venkat Chellam

Hi all,

I am using C# dot net application. I need to send a bunch of records
to the stored procedure in the oracle back end. how do i create
oracleparamter object from the front end. I mean i need to sedn array
of oracleparamters and how does the stored procedure the back end will
accept it. how do i write the stored procedure. I don't want to insert
row by row and call the storedprocedure for each row, rather i want to
do it in one shot. I am using microsoft oracle client


Any help would be greately appreciated

venky
 
Venkat Chellam said:
Hi all,

I am using C# dot net application. I need to send a bunch of records
to the stored procedure in the oracle back end. how do i create
oracleparamter object from the front end. I mean i need to sedn array
of oracleparamters and how does the stored procedure the back end will
accept it. how do i write the stored procedure. I don't want to insert
row by row and call the storedprocedure for each row, rather i want to
do it in one shot. I am using microsoft oracle client
Click to expand...

The feature you're looking for is called Array Binding, and the Microsoft
Oracle Client does not support it. You'll need ODP.NET from oracle.

David
 
Back
Top