date

while passing date to procedure take data type as varchar(100) and to convert use PKG_FUNCTIONS.TO_DATE