Hi all,



Can anyone Please help me out and let me know what's the problem



is.I am using ADODB to access Oracle Stored Procs from my application.The



sored Proc has table type output variables. I am attaching the code 



Dim objConn As New ADODB.Connection



Dim objCmd As New ADODB.Command



Dim objRs As New ADODB.Recordset



Dim objParam As New ADODB.Parameter



On Error GoTo ErrHandle:



objConn.Open "CRTRACKER", "CRTRACKER", "CRTRACKER"



With objCmd



Set .ActiveConnection = objConn



.CommandText = "{call PKCRPN01.PR_GET_ASSOCIATED_CRPNS(" & _



" ?, {resultset



10,out_var_crpn,out_var_work_orders},?,?)}"



.CommandType = adCmdText



.Parameters(0).Value = 8641



Set objRs = .Execute()



End With



ErrHandle:



MsgBox Err.Description



MsgBox Err.Source



 



The definition of the stored proc is as



CREATE OR REPLACE PACKAGE PKCRPN01 AS



type tbl_crpn_info is table of varchar2(15) index by binary_integer;



type tbl_work_orders_info is table of varchar2(200) index by



binary_integer;



PROCEDURE PR_GET_ASSOCIATED_CRPNS(



in_i_employee_number IN INTEGER,



out_var_crpn OUT tbl_crpn_info,



out_var_work_orders IN OUT tbl_work_orders_info,



out_i_no_of_recs OUT INTEGER,



out_v_error_code OUT varchar2 



);



When I use the same I get an error message saying "Invaid Parameter Type"



Regards



Amit