pass date field with to_date onverter using wm.db.call service

1

Hi ,

  1. I need to pass date with to_date converter to a Oracle SP using db.call 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.

2

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