Database Security Products (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center