Invalid length for DATE or NUMBER bind variable (ORACLE)
Posted: Mon 08 Mar 2021 16:29
We ran into another issue with the recent version (8.4.1):
"ORA-01483: invalid length for DATE or NUMBER bind variable"
There is no no explicit PREPARE call in our codes, until the recent version it was working fine.
You can reproduce the problem using the following code:
"ORA-01483: invalid length for DATE or NUMBER bind variable"
There is no no explicit PREPARE call in our codes, until the recent version it was working fine.
You can reproduce the problem using the following code:
Code: Select all
procedure TfrmMain.Button2Click(Sender: TObject);
begin
// SQL > select * from user_tables where table_name = :p_string and last_analyzed = :p_date
conMain.Connect;
// if I add the following code it is working fine:
// UniQuery1.Prepare;
UniQuery1.Params[0].Value := '181000020000000129610030';
UniQuery1.Params[1].Value := Date;
UniQuery1.Open;
end;