ORA-06502 NULL INDEX TABLE KEY VALUE: ON INSERT WITH A COMPOUND TRIGGER
(Doc ID 1233971.1)
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 22.214.171.124 to 126.96.36.199 - 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 188.8.131.52.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|