This discussion is archived
2 Replies Latest reply: Jun 22, 2013 11:05 AM by jmft2012 RSS

How to enable audit log setting in PRMAUDIT table.

1001854 Explorer
Currently Being Moderated


I wanted to enable audit tracking in PRMAUDIT table.

I had oracle XE database which is already installed.I don't want to do reinstallation.

please tell me, how i can enable this auditing.

I tried to run - exec settings_write_bool(3,'database.audit','Enabled');

but getting error as

"ORA-06550: line 1, column 7:
PLS-00201: identifier 'SETTINGS_WRITE_BOOL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error."


Please help me to resolve this issue.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points