ORA-00976: Specified pseudocolumn or operator not allowed here - Why? 11.2.0.2
n_row:=n_row+1;
INSERT INTO ldx_snapshot_res_rows
(snapshot_id,
data1,
data2,
data3,
data4,
data5,
data6,
seq_no
)
VALUES (n_in_snapshot_id,
r_get_invoice_data.invoice_date,
r_get_invoice_data.invoice_no,
r_get_invoice_data.style,
r_get_invoice_data.value_for_duty_tot,
r_get_invoice_data.vat_10,
r_get_invoice_data.vat_18,
ROWNUM
);
END LOOP;
Is this behaviour new in 11.2.0.2? We have just moved from 10.2.0.4 to 11.2.0.2
Regards
U