OCI-22060: argument [2] is an invalid or uninatialized number

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
holger_nis
Posts: 5
Joined: Wed 26 Nov 2014 10:02

OCI-22060: argument [2] is an invalid or uninatialized number

Post by holger_nis » Tue 12 Dec 2017 11:04

Please ceate a teable like that

Code: Select all

CREATE TABLE ATEST
( ID NUMBER (9,0) NOT NULL,
  ID12 NUMBER (12,0),
  ID16 NUMBER (16,0),
  ID20 NUMBER (20,0),
  ID28 NUMBER (28,0),
  IDNUM NUMBER,
  DM DATE)
/


ALTER TABLE ATEST ADD
( CONSTRAINT ATEST_PK PRIMARY KEY(ID) )
/

CREATE OR REPLACE TRIGGER ATEST_BIUR 
BEFORE  INSERT OR UPDATE 
ON ATEST 
REFERENCING OLD AS OLD NEW AS NEW 
FOR EACH ROW
BEGIN
  :new.DM := SYSDATE;
END;
/

INSERT INTO ATEST( ID, ID12, ID16, ID20) VALUES( 123456789, 123456789012, 1234567890123456, 1234567890123467894));
COMMIT;
Now create a Delphi form to edit the table using
* TOraSession: SQL*Net connection; Options.EnableLargeInt := True; Options.EnableNumbers := True
* TSmartQuery: DmlRefresh := True; Options.ReturnParams := True
* TOraDatasource
* Data grid

When editing data, you will get the error mentioned in the subject.

Environment:
* Oracle DB 11.2.0.2.0
* Oracle Client 12.1.0.0.0
* Windows 7

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

Re: OCI-22060: argument [2] is an invalid or uninatialized number

Post by MaximG » Fri 23 Feb 2018 07:06

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

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

Re: OCI-22060: argument [2] is an invalid or uninatialized number

Post by MaximG » Tue 13 Mar 2018 13:59

Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next ODAC build. Currently, we can send you a night build of ODAC with the fix. For this, please specify your license number and the exact version of Delphi you are using via the e-support form ( devart.com the "Support"\"Request Support" menu)

Post Reply