hi friends,
I need a help calling oracle stored procedure in classic asp and am using oraoledb provider. When I call Stored procedure with ref cursor its give error:-
Error Type:
OraOLEDB (0x80040E14)
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROC_CHCL_STATUS_ARA' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
/aisdev/ais_reports/ais_cl_status_ara.asp, line 187
*********************************************************
Please find my stored procedure
*********************************************************
CREATE OR REPLACE PROCEDURE Proc_Chcl_Status_Ara(
p_List OUT Cpa_Package.cpaType
)
AS
BEGIN
OPEN p_List FOR
SELECT UPPER(LTRIM(RTRIM(ara_last_name))||' '||LTRIM(RTRIM(ara_first_name))) ara, COUNT(1) FROM ADOPTION_CASES WHERE case_end_date IS NULL AND ADOPTION_CASES.ASSIGNED_END_DATE IS NULL
AND cws_number ='S0216'AND ADOPTION_CASES.ASSIGNMENT_CODE='P'
AND ADOPTION_CASES.file_no NOT LIKE 'PR%'
AND ADOPTION_CASES.WORKER_TYPE NOT IN ('F')
GROUP BY LTRIM(RTRIM(ara_last_name))||' '||LTRIM(RTRIM(ara_first_name))
ORDER BY LTRIM(RTRIM(ara_last_name))||' '||LTRIM(RTRIM(ara_first_name));

END;
/
*********************************************************
Please find my asp code also
*********************************************************
Dim param1,param2,p_List,param

Set Cmd = Server.CreateObject("ADODB.Command")
set objparm = server.CreateObject("ADODB.parameter")
Set objRs = Server.CreateObject("ADODB.Recordset")
set Cmd.activeconnection=Cnn

Cmd.CommandText = "Proc_ChCl_Status_ara"
Cmd.CommandType = adCmdStoredProc

set param1 = Cmd.CreateParameter("p_List1",adVarChar,adParamOutput,10)
Cmd.Parameters.Append param1
Set objRs = Cmd.Execute

please help me
regards
thiru.