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

[holger_nis]

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]

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

[MaximG]

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)