Date input parameter

[kthomas]

For this procedure call:
spMobileX.CallProcedure('MILEAGE_ACC',
['PAREA',edtArea.Text,
'PSTART_DATE',dtpStart.Date,
'PEND_DATE',dtpEnd.Date]) ;

I get a "PLS-00306: Wrong number or types of arguments in call to MILEAGE_ACC". The parameters are correct (input text,date,date). If I use Delphi's FormatDateTime & convert the dates to "dd-mon-yyyy", then it works fine. Is this always necessary when passing in date parameters?

Thanks,
-Kent

 

[Marco Kalter]

Two questions:

When you set the Debug property of the package to True, is the displayed procedure call as you expected?

Is the data type of dtpStart.Date and dtpEnd.Date really a TDateTime? If not, it may be necessary to apply a typecast or conversion to TDateTime.

------------------
Marco Kalter
Allround Automations