Skip to Main Content
  • Questions

  • sourcecode view of logmnr_ddl_trigger_proc procedure

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, sunny.

Asked: August 29, 2020 - 8:12 am UTC

Last updated: August 31, 2020 - 5:29 am UTC

Version: 12c

Viewed 1000+ times

You Asked

User:- Sys

CREATE OR REPLACE NONEDITIONABLE TRIGGER
SYS.LOGMNRGGC_TRIGGER
BEFORE ddl ON DATABASE
CALL logmnr_ddl_trigger_proc
/

I want to see source code of logmnr_ddl_trigger_proc. so how it is possible?

and Connor said...

You can get the source of a PLSQL routine via the following query

select text
from dba_source
where name = 'LOGMNR_DDL_TRIGGER_PROC'
and owner = 'SYS';


If the code has been wrapped (ie, looks like gibberish) then its not published by Oracle for public consumption

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library