Possible behavior change of a SQL in 19c (vs 12.1)
Following update statement in a stored proc is executing without issues in 12.1
UPDATE t1
SET description = description
WHERE EXISTS
(SELECT 1
FROM all_part_tables a) and rownum=1
RETURNING id INTO v_id;
In 19c, it gives an error ORA-1031 (insufficient privileges),
But if we remove the RETURNING clause, it executes without errors.
Any suggestions / comments appreciated.
Thanks,
GV