Guru's,
I have oracle sp with the below types defined, and my sp uses these
types for outparameter, i am using DAAB.
Need to know how to execute this kind of SP.
highly appreciate if you can get me solution for this..
Thanks in advance..
-------
TYPE SECTTABTYPE IS TABLE OF VARCHAR2(5) INDEX BY BINARY_INTEGER;
TYPE MCHTABTYPE IS TABLE OF VARCHAR2(7) INDEX BY BINARY_INTEGER;
TYPE NUMTABTYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
------------
PROCEDURE GET_CAP( P_SECTIONS IN VARCHAR2,
P_NUM_DAYS IN NUMBER,
P_PROC_ALL_MCHS IN VARCHAR2,
P_SECTS OUT SECTTABTYPE,
P_MCHS OUT MCHTABTYPE,
P_RQDS OUT NUMTABTYPE,
P_PLANCAPS OUT NUMTABTYPE) IS
--some code
********
// .Net code for executing SP using DAAB..
DBCommandWrapper dbCommandWrapper =
db.GetStoredProcCommandWrapper("dcp_PKG.get_cap");
dbCommandWrapper.AddInParameter("P_SECTIONS", DbType.String, section);
dbCommandWrapper.AddInParameter("P_NUM_DAYS", DbType.Int32,NumDays);
dbCommandWrapper.AddInParameter("P_PROC_ALL_MCHS", DbType.String, Mac);
dbCommandWrapper.AddOutParameter("P_SECTS", DbType.String,20);
dbCommandWrapper.AddOutParameter("P_MCHS", DbType.String,24);
dbCommandWrapper.AddOutParameter("P_RQDS", DbType.Int32,4);
dbCommandWrapper.AddOutParameter("P_PLANCAPS", DbType.Int32,4 );
//Execute the stored procedure
db.ExecuteDataSet(dbCommandWrapper);