since UniDAC 8.4 we have problems with StoredProcedures. ( see examples below )
With version 8.3.2 it works without problems in both cases.
TIMESTAMPTEST in this examples is a timestamp parameter.
DBMS Firebird 3
Code: Select all
lStoredProcedure.StoredProcName := 'TEST';
lStoredProcedure.Prepare;
lStoredProcedure.ParamByName( 'TIMESTAMPTEST').Value := '21.04.2021';
lStoredProcedure.ExecProc;
//Errormessage: "value exceeds the range for valid timestamps."
Code: Select all
lStoredProcedure.StoredProcName := 'TEST';
lStoredProcedure.Prepare;
lStoredProcedure.ParamByName( 'TIMESTAMPTEST').AsDateTime := StrToDateTime( '21.04.2021');
lStoredProcedure.ExecProc;
// works