Re: Auditing: Trigger or Audit_Trail?

On Tue, 2 Mar 2004 21:33:26 +0000, in comp.databases.oracle.server, Pete Finnigan <plsql_at_petefinnigan.com> scribbled:

>Hi Teresa,
>
>Thanks for your comments on my papers. I don't have 8.1.5 anymore to
>test with but i suspect that you have nailed the issue. If you have the
>final parameter static_policy missing then just leave it out. It should
>work the same. The parameter is to tell Oracle whether the predicate
>will always be the same (or not) each time the policy function is
>executed.

Okay, that makes sense. It seems to work okay so far.

>I am not sure what your issue is with the final slash, it's needed to
>execute the PL/SQL.

I get compile error if I leave it in. The code ran fine when I took it out. I have no idea why.

I will be working through more of your examples and will get back with the group if I have any more questions. Thanks so much!

-- 
Teresa Redmond
Programmer/Analyst II
Anteon Corporation
tredmond *at anteon dot# com