Re: New audit trigger question

On Fri, 19 Mar 2004 20:05:44 -0500, in comp.databases.oracle.server, "Mark C. Stock" <mcstockX_at_Xenquery .com> scribbled:

>
>"Teresa Redmond" <XKEAAGIPVIEZ_at_spammotel.co> wrote in message
>news:50436416098279773204644f263a2823_at_news.teranews.com...

>| On Fri, 19 Mar 2004 15:07:24 +0100, in comp.databases.oracle.server,
>| As in, user has opened Forms Designer, opened a form, connected to the
>| database, but has not selected any records, he's just working on the
>| form. The form doesn't load any records automatically, either; you
>| have to select from a record number from a LOV to get a record before
>| one opens in the form. Does that make sense? I know it's hard to get
>| the idea across.
>
>teresa, your description makes sense, but in order for your trigger to fire,
>someone must be issuing an update -- if you think it's the form, run it in
>trace mode (see runtime options, i'm sure there's one in there, or check
>V$SQL for update statements

That's what I thought, that an update had to be issued for the trigger to fire, but he said he did not update, he was just working on the form. I'll do as you say and see what happens. Thanks!

-- 
Teresa Redmond
Programmer/Analyst III
Anteon Corporation
tredmond at anteon dot com