Brahmam Eswar schrieb am 09.07.2018 um 11:58: > I'm trying to reset array element to null. but 3rd line of below snippet is > giving the compilationĀ error. > > > FOR indx_1 IN array_lower(X, 1)..array_upper(X, 1) LOOP > IF X[indx_1].REFERENCE_VALUE = 'ABC' THEN > X[indx_1].REFERENCE_VALUE:=''; > END IF; > END LOOP;
What data type is X exactly? It looks like a composite record type. (Also: an empty string '' is not the same as NULL)