PL/SQL (MOSC)

MOSC Banner

Creating trigger: ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of

edited Jun 3, 2019 3:20AM in PL/SQL (MOSC) 11 commentsAnswered

Hi all,

Our customer executes a script, creating trigger on Oracle DB 12.2 editionable enabled:

create or replace trigger MVOA_FND_ATTACHED_DOCS_DEL

before delete on FND_ATTACHED_DOCUMENTS

referencing old as OLD new as NEW
for each row

DECLARE

...

An error 'ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object' occurs.

I can not reproduce the issue. 'Create or replace trigger' command is rerunnable in my envinronment (schema is also editionable enabled).

What could be a reason of the exception and a difference?

On my env  select editionable from all_objects where object_name = 'MVOA_FND_ATTACHED_DOCS_DEL'

Tagged:

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