Invalid length for DATE or NUMBER bind variable (ORACLE)

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tcxbalage
Posts: 23
Joined: Sat 04 Apr 2020 10:45

Invalid length for DATE or NUMBER bind variable (ORACLE)

Post by tcxbalage » 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:

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;


tcxbalage
Posts: 23
Joined: Sat 04 Apr 2020 10:45

Re: Invalid length for DATE or NUMBER bind variable (ORACLE)

Post by tcxbalage » Wed 10 Mar 2021 17:56

Can I get some feedback, please?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Invalid length for DATE or NUMBER bind variable (ORACLE)

Post by MaximG » Thu 11 Mar 2021 15:14

We could not reproduce the error according to your description. To further investigate the issue, compose and send us a small sample, execution of which causes the issue. You can do it via the e-support form https://www.devart.com/company/contactform.html
What Oracle version are you using ?

tcxbalage
Posts: 23
Joined: Sat 04 Apr 2020 10:45

Re: Invalid length for DATE or NUMBER bind variable (ORACLE)

Post by tcxbalage » Fri 16 Apr 2021 08:03

The mentioned problem has been fixed in 8.4.3, no error received, thanks for the help.

Post Reply