Sending multpile rows to Oracle using ADO.Net anbd Stored procedur

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I want to process an ASP.Net datagrid and send all rows to the database in
one roundtrip, rather than do the process of new, save, new, save or edit,
save, edit save etc.
Does anyone know how I can pass an array or other structure of rows to an
Oracle stored procedure for inserting or updating, also in such a way that I
can process ewach row inidvidually within the stored procedure as I have
different actions to take depending on the values being updated
Thanks in advance
 
Consider usnig the XML functionality of Oracle to handle the multiple rows.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
You can use ODP.net (Oracle Data Provider)

Look into Array binding in ODP.net. It's very easy to use and will allow
for your bulk inserts....

If want to process each row individually, then look into PL/SQL associative
array... I haven't used it but it seems straight forward

This is all part of the oracle docs once you install odp.net
 
Back
Top