How to pass a table array to an Oracle stored procedure

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

Guest

I have an Oracle SPROC which takes as one of its IN parameters a table array
(e.g. type charArray is table of varchar2(255)...)

How can I call that SPROC and pass it the table array from ADO.NET?

Thanks.
 
Surf to http://otn.oracle.com and join Oracle Tech Net. Then, download
ODP.NET for your version of Oracle (different for 9i minus and 10g). Move
away from OracleClient and start using ODP.NET.

OracleClient is a focus of Microsoft's, but realistically, it is an 8i
implementation. New features of 9i are not supported. Fortunately, the
ODP.NET providers are very similar in implementation (exact on many methods).

---

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

***************************
Think Outside the Box!
***************************
 
Surf to http://otn.oracle.com and join Oracle Tech Net. Then, download
ODP.NET for your version of Oracle (different for 9i (and earlier) and 10g).
Move away from OracleClient and start using ODP.NET:
(download here) =
http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html

OracleClient is a focus of Microsoft's, but realistically, it is an 8i
implementation. New features of 9i are not supported. Fortunately, the
ODP.NET providers are very similar in implementation (exact on many methods).

NOTE: There are samples for most types of hard problems you might encounter.
Not sure if a table data type is one of the problems sampled, but it is worth
a surf around the site to find out.

---

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

***************************
Think Outside the Box!
***************************
 
Back
Top