Re: Help: Report trigger does not fire.
From: Peter L <news_at_abc.freeserve.co.uk>
Date: Fri, 22 Oct 1999 19:29:15 +0100
Message-ID: <7urn7t$698$1_at_news8.svr.pol.co.uk>
Date: Fri, 22 Oct 1999 19:29:15 +0100
Message-ID: <7urn7t$698$1_at_news8.svr.pol.co.uk>
tianh_at_my-deja.com wrote in message <7ug3g4$4en$1_at_nnrp1.deja.com>...
>Report 3.0 question: I used After Report Trigger to Delete a
>temp-table,(this temp-table is created in Before form trigger), but
>after the report runa, this temp-table is still in the DB. (I check it
>through Sql*Plus).
>
>Since in the After Report Trigger, the only statement is to drop the
>temp-table, so I think the reason is this Trigger does not fire at all.
>
Are you issuing a commit after the delete? If you are trying to drop the
table, not just delete the contents, I think you'd have to use dynamic SQL
created in the PL/SQL trigger.
Received on Fri Oct 22 1999 - 20:29:15 CEST