day of month must be between 1 and last day of month

[SunilChauhan]

Dear all,

i am trying get stored procedure in qlikview but i am facing problem

Ora:01874 day of month must be between 1 and last day of month

oracle connection string

select

ID,

PROD.loan_p_in_qv

(3954,'01-Apr-10','30-NOV-10') as amount

from

tab1; is not working

while

sql EXEC sp_loan_p_in_qv 3954,'01-APR-10','30-NOV-2010' is executing

help me

regards

Tom