Re: Auditing: Trigger or Audit_Trail?

Teresa Redmond <NJZLIRWUWYGI_at_spammotel.com> wrote in message news:<5e62d5ca463176642a449c3aa29df6ca_at_news.teranews.com>...
> 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!

Hi,

Regarding the / problem, do you use Sql Scratchpad to run these examples? With this tool, a final slash generates ORA-00911, it is its "normal" behavior. Received on Thu Mar 04 2004 - 04:02:34 CST