Re: Indirect use of cursors

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 31 Oct 2005 07:18:16 -0800
Message-ID: <1130771896.453994.128910@g47g2000cwa.googlegroups.com>

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 -- Received on Mon Oct 31 2005 - 09:18:16 CST