ORA-06502 NULL INDEX TABLE KEY VALUE: ON INSERT WITH A COMPOUND TRIGGER
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 220.127.116.11 to 18.104.22.168 - Release: 11.2 to 11.2
Information in this document applies to any platform.
INSERT INTO aaa_test(id, col1) VALUES(1, 1)
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-21779: duration not active
ORA-06512: at "CTTEST.T_AAA_TEST", line 29
ORA-04088: error during execution of trigger 'CTTEST.T_AAA_TEST'
A wrong initialization of variables occurs in the "before statement".
When the INSERT is tried a second time it works (and also for subsequent times).
Same code works in 22.214.171.124.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms