Re: Indirect use of cursors

Mark D Powell wrote:
> The compilation state of triggers depends on the Oracle version in use.
>
> >From the 10g Application Developers Guide - Fundamentals
> >> Triggers, in contrast, are fully compiled when the CREATE TRIGGER statement is entered, and the pcode is stored in the data dictionary. Hence, firing the trigger no longer requires the opening of a shared cursor to run the trigger action. Instead, the trigger is executed directly. <<
>
> This was also true with version 9.2
>
> HTH -- Mark D Powell --

And 8i.

http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76939/adg13trg.htm#6276 Received on Mon Oct 31 2005 - 18:30:50 CST