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;
* 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