4 Replies Latest reply: Jun 28, 2013 12:24 PM by jack m RSS

    DBMS_AUDIT_MGMT.set_last_archive_timestamp & AUDIT_TRAIL_ALL

    jtokarsk
      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