Hi I have a proc with 3 parameters like

(p_startdate INvarchar2default TRUNC(ADD_MONTHS(SYSDATE,-1),'MM'), p_enddate INvarchar2default LAST_DAY(sysdate),
p_record OUT sys_refcursor)


I exec it from oracle 11 as follows:
DECLARE
TYPE Cursor_Type_3 IS REF CURSOR;
P_RECORD Cursor_Type_3;
BEGIN
-- Now Call the stored program
dwpa_esafety.p_esafety_curr_ml_yr
(p_startdate=>'07/01/12',
p_enddate=>'07/18/12',
p_record=>p_record);
-- Output the results
:a0 := P_RECORD;
END;

Iam trying to call it from Pentaho like
{call DWPA_ESAFETY.P_ESAFETY_CURR_ML_YR(${p_startdate},${p_enddate})} or

{call DWPA_ESAFETY.P_ESAFETY_CURR_ML_YR(
'07/01/12','07/18/12')}

Nothing works, can anybody help me.