This discussion is archived
4 Replies Latest reply: Jun 28, 2013 10:24 AM by jack m RSS

DBMS_AUDIT_MGMT.set_last_archive_timestamp & AUDIT_TRAIL_ALL

jtokarsk Newbie
Currently Being Moderated
Hi folks, I have starred at this for a while. When I issue the following

BEGIN
DBMS_AUDIT_MGMT.set_last_archive_timestamp(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,
last_archive_time => SYSTIMESTAMP-5);
END;
/

I keep getting the following error:

ERROR at line 1:
ORA-46250: Invalid value for argument 'AUDIT_TRAIL_TYPE'
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 61
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 2233
ORA-06512: at line 2

Yet as near as I can tell this is a valid constant (http://docs.oracle.com/cd/E11882_01/appdev.112/e10577/d_audit_mgmt.htm#BABIDGEA)
for this procedure(http://docs.oracle.com/cd/E11882_01/appdev.112/e10577/d_audit_mgmt.htm#BABBHHGC).

Has anyone ran into this?

Edited by: jtokarsk on Mar 23, 2012 5:47 PM

Legend

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