pass date field with to_date onverter using service

Hi ,

  1. I need to pass date with to_date converter to a Oracle SP using service.But I am getting hte error
    ORA-01858: a non-numeric character was found where a numeric was expected
    ORA-06512: at line 1

  2. Iam able to pass the date with to_date to SP using exeSQL service .but I am not getting the procedure output variable as output from execSQL service.

Please some one give me the solution to any one of the above my problems.

Check the inputs for the procedure and check what inputs did u mentioned in the db service adapter call.