Passing an array from .Net application to Oracle stored procedure?

You should use DB-defined nested table types to pass an array to PL/SQL. Take a look at this nice tutorial it might help you.

You should use DB-defined nested table types to pass an array to PL/SQL. Take a look at this nice tutorial, it might help you.

Thanks for your answer, but this approach requires Oracle . NET driver Oracle. DataAccess whereas I'm using Microsoft System.Data.OracleClient.

– Jimmy Oct 27 '10 at 11:10 @Jimmy I'm beg my pardon, I was inattentive. Must admit that I don't know how to solve your issue with System.Data. OracleClient :) – andr Oct 27 '10 at 12:01 1 It'd be best to switch to the Oracle drivers.

More features, and they'll be supported out in to the future. Here's another example of a procedure that accepts an array. Link – MonkeyWrench Oct 27 at 19:45.

Jimmy, the System.Data. OracleClient does not support arrays. social.msdn.microsoft.com/Forums/en-US/a... Depending on your need, you will either need to implement this via nested table types (via UDTs or assoc.

Arrays) using the ODP. Net clients. This is probably a good direction to go, esp.

Since . Net 4.0 has deprecated System.Data.OracleClient. But if you are stuck with the System.Data.

OracleClient and you are really just trying to do a variable in-list, you can do this by passing in a string and following some of these suggestions: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:210612357425 hope this helps.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.