Home
Home 		Customize
Customize		 Help
Help 		Contact us
Contact Us

Virtual Book about 'trigger'


Table of Contents: Virtual Book about 'trigger'

This virtual book brings together the most relevant topics about 'trigger'. The topics are grouped into these categories:
[Back to top]

Introductory Information about 'trigger'

This category includes definitions, overviews, concepts, restrictions, frequently asked questions, and explanations of how things work. This is where you should start if you are not familiar with this subject area.

Results in this section come from these books:

[ Next book ]

Concepts

Database Triggers

Database Triggers

Triggers

Introduction to Triggers

Figure 19-1 Triggers

How Triggers Are Used

Some Cautionary Notes about Triggers

Figure 19-2 Cascading Triggers

Triggers versus Declarative Integrity Constraints

Parts of a Trigger

Figure 19-3 The REORDER Trigger

Triggering Event or Statement

Trigger Restriction

Trigger Action

Types of Triggers

Row Triggers and Statement Triggers

Row Triggers

Statement Triggers

BEFORE and AFTER Triggers

BEFORE Triggers

AFTER Triggers

Trigger Type Combinations

Sample Package and Trigger for SAL Table

INSTEAD OF Triggers

Example of an INSTEAD OF Trigger

INSTEAD OF Triggers on Nested Tables

Accessing the Attributes of the Parent Row Inside a Nested Table Trigger

Firing of Nested Table and View Triggers

Triggers on System Events and User Events

Triggers on LOGON and LOGOFF Events

Triggers on DDL Statements

Triggers on DML Statements

Trigger Execution

The Execution Model for Triggers and Integrity Constraint Checking

Data Access for Triggers

Storage of PL/SQL Triggers

Execution of Triggers

Dependency Maintenance for Triggers

Trigger Restrictions

Database Triggers

[ Previous book | Next book ]

SQL Reference

DML Trigger Example with Restriction - call_procedure_statement

[ Previous book | Next book ]

Application Developer's Guide - Fundamentals

Restrictions on Creating Triggers

System Trigger Restrictions

[Next book]

Glossary

event triggers - Glossary

trigger - Glossary

[Back to top]

Tasks Related to 'trigger'

This category includes how-to information, both detailed procedures and general usage information and guidelines. The tasks are listed alphabetically, with shortcut links that jump to places within the list. For example, if you want to find Creating, look for a link labeled CRE.

Shortcuts to Tasks

ACC AUD CAL COM CRE DEB DES DIS DRO ENA FIR HOW LIS MOD NAM
REC REP TRI USI

Accessing Column Values in Row Triggers

Accessing the Attributes of the Parent Row Inside a Nested Table Trigger

Auditing Through Database Triggers

Auditing with Triggers

Calling a Procedure in a Trigger Body Example - call_procedure_statement

Calling Java from Database Triggers

Compiling Triggers

Creating and Configuring Asynchronous Component Invocation Triggers

Creating Triggers

Debugging Triggers

Designing Triggers

Disabling Triggers

Disabling Triggers

Dropping the Insert Trigger and the Global-Variable Package

Enabling and Disabling Triggers

Enabling and Disabling Triggers

Enabling Triggers

Enabling Triggers

Enabling Triggers Example - ALL TRIGGERS

Firing of Nested Table and View Triggers

How Do I Determine if the LOB Column with a Trigger is Being Updated?

Listing Information About Triggers

Modifying or Disabling Triggers

Modifying Triggers

Naming Triggers

Recompiling Triggers

Replacing Insert Triggers with Integrity Constraints

Triggering Event or Statement

Triggering Event Publication

Triggering Statement

Triggering the SQLJ Translator

Using an Update Trigger

Using Autonomous Triggers

Using INSTEAD-OF Triggers to Control Mutating and Validation

Using the PL/SQL API from a Database Trigger

Using Triggers

Using Views and Database Triggers

[Back to top]

Examples of 'trigger'

This category includes sample procedure and sample code, to illustrate how to perform tasks or use features.

Results in this section come from these books:

[ Next book ]

Concepts

Example of an INSTEAD OF Trigger

Figure 19-1 Triggers

Figure 19-2 Cascading Triggers

Figure 19-3 The REORDER Trigger

Sample Package and Trigger for SAL Table

[ Previous book | Next book ]

SQL Reference

DML Trigger Example with Restriction - call_procedure_statement

Calling a Procedure in a Trigger Body Example - call_procedure_statement

Database Event Trigger Example - call_procedure_statement

DDL Trigger Example - call_procedure_statement

Disable Trigger Example - COMPILE

DML Trigger Example - call_procedure_statement

DROP TRIGGER Example - trigger

Enable Trigger Example - COMPILE

Enabling Triggers Example - ALL TRIGGERS

INSTEAD OF Trigger Example - call_procedure_statement

[ Previous book | Next book ]

Application Developer's Guide - Fundamentals

Examples of Trigger Applications

INSTEAD OF Trigger Example

[ Previous book | Next book ]

Message Broker Administration Guide

Table 4-23  ACI Queue Trigger Administrative Attributes

Table 4-24  ACI Topic Trigger Administrative Attributes

[ Previous book | Next book ]

Spatial User's Guide and Reference

Example B-1 Insert Trigger for Metadata Consistency

[Back to top]

Detailed Reference Information on 'trigger'

This category includes syntax for associated statements, APIs, or commands.

Results in this section come from these books:

[ Next book ]

Reference

ALL_INTERNAL_TRIGGERS

ALL_TRIGGERS

ALL_TRIGGER_COLS

DBA_INTERNAL_TRIGGERS

DBA_TRIGGERS

DBA_TRIGGER_COLS

USER_INTERNAL_TRIGGERS

USER_TRIGGERS

USER_TRIGGER_COLS

[ Previous book | Next book ]

SQL Reference

Additional Prerequisites for Constraints and Triggers - ALTER TABLE

ALL TRIGGERS - ALTER TABLE

ALTER TRIGGER

CREATE TRIGGER

DROP TRIGGER

trigger - ALTER TRIGGER

trigger - DROP TRIGGER

trigger - CREATE TRIGGER

[ Previous book | Next book ]

Enterprise Manager SNMP Support Reference Guide

oraRepDisabledTriggers

[ Previous book | Next book ]

PL/SQL User's Guide and Reference

Database Triggers

[ Previous book | Next book ]

Utilities

TRIGGERS

[Back to top]

Troubleshooting Information About 'trigger'

This category includes information about debugging, preventing errors or handling them when they occur, frequently asked questions, and relevant error messages.

Results in this section come from these books:

[ Next book ]

Concepts

Trigger Restriction

Trigger Restrictions

[ Previous book | Next book ]

SQL Reference

DML Trigger Example with Restriction - call_procedure_statement

[ Previous book | Next book ]

Application Developer's Guide - Fundamentals

Debugging Triggers

Error Conditions and Exceptions in the Trigger Body

Restrictions on Creating Triggers

System Trigger Restrictions

Triggers and Handling Remote Exceptions

[ Previous book | Next book ]

Error Messages

ORA-04070 invalid trigger name

ORA-04072 invalid trigger type

ORA-04073 column list not valid for this trigger type

ORA-04075 invalid trigger action

ORA-04077 WHEN clause cannot be used with table level triggers

ORA-04079 invalid trigger specification

ORA-04080 trigger 'string' does not exist

ORA-04081 trigger 'string' already exists

ORA-04082 NEW or OLD references not allowed in table level triggers

ORA-04083 invalid trigger variable 'string'

ORA-04084 cannot change NEW values for this trigger type

ORA-04086 trigger description too long, move comments into triggering code

ORA-04088 error during execution of trigger 'string.string'

ORA-04089 cannot create triggers on objects owned by SYS

ORA-04090 'string' specifies same table, event and trigger time as 'string'

ORA-04091 table string.string is mutating, trigger/function may not see it

ORA-04092 cannot string in a trigger

ORA-04093 references to columns of type LONG are not allowed in triggers

ORA-04094 table string.string is constraining, trigger may not modify it

ORA-04095 trigger 'string' already exists on another table, cannot replace it

ORA-04096 trigger 'string' has a WHEN clause which is too large, limit 2K

ORA-04097 DDL conflict while trying to drop or alter a trigger

ORA-04098 trigger 'string.string' is invalid and failed re-validation

ORA-04099 trigger 'string' is valid but not stored in compiled form

ORA-06534 cannot access Serially Reusable package string in the context of a trigger

ORA-12001 cannot create log: table 'string' already has a trigger

ORA-12430 label of trigger must equal table

ORA-25000 invalid use of bind variable in trigger WHEN clause

ORA-25001 cannot create this trigger type on views

ORA-25002 cannot create INSTEAD OF triggers on tables

ORA-25003 cannot change NEW values for this column type in trigger

ORA-25004 WHEN clause is not allowed in INSTEAD OF triggers

ORA-25005 cannot CREATE INSTEAD OF trigger on a read-only view

ORA-25008 no implicit conversion to LOB datatype in instead-of trigger

ORA-25009 Nested table clause allowed only for INSTEAD OF triggers

ORA-25017 cannot reference NEW ROWID for movable rows in before triggers

ORA-26086 direct path does not support triggers

ORA-29528 invalid Java call in trigger string

ORA-29529 invalid function or method call string in trigger string

ORA-30500 database open triggers and server error triggers cannot have BEFORE type

ORA-30501 instance shutdown triggers cannot have AFTER type

ORA-30502 system triggers cannot have INSERT, UPDATE, or DELETE as triggering events

ORA-30503 system triggers cannot have a REFERENCING clause

ORA-30504 system triggers cannot have a FOR EACH ROW clause

ORA-30505 system triggers should not reference a column in a WHEN clause

ORA-30506 system triggers cannot be based on tables or views

ORA-30507 normal triggers cannot be based on a schema or a database

ORA-30508 client logon triggers cannot have BEFORE type

ORA-30509 client logoff triggers cannot have AFTER type

ORA-30510 system triggers cannot be defined on the schema of SYS user

ORA-30511 invalid DDL operation in system triggers

ORA-30513 cannot create system triggers of INSTEAD OF type

ORA-30514 system trigger cannot modify tablespace being made read only

PCB-00306 CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

PRO-00140 CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

SDO-01700 failed to create base trigger on partition

SDO-01701 failed to enable base trigger on partition

SQL*Loader-00937 parallel load requested and string has enabled triggers or constraints

SQL*Loader-00938 partition load requested and string has enabled triggers or constraints

SQL*Loader-00947 subpartition load requested and string has enabled triggers or constraints

SQL*Loader-00966 Error number disabling all triggers on table string

[ Previous book | Next book ]

Replication

Problems with Replicated Procedures or Triggers

[Back to top]

Index Entries about 'trigger'

The index entries show related terms, and identify the most important places where your subject is mentioned.
CR RE DI RO ST MU AF DR DB AD LO EN AL US DA TR EV IN OR AU BE

Index Entries

ADMINISTER ANY TRIGGER system privilege (SQL Reference)
AFTER triggers (SQL Reference)
     [entry #2] (Concepts)
auditing and (Administrator's Guide)
     [subentry #2] (Application Developer's Guide - Fundamentals)
     [subentry #3] (Application Developer's Guide - Fundamentals)
correlation names and (Application Developer's Guide - Fundamentals)
defined (Concepts)
specifying (Application Developer's Guide - Fundamentals)
when fired (Concepts)
ALL_TRIGGERS view (Reference)
ALL_TRIGGER_COLS view (Reference)
ALTER ANY TRIGGER system privilege (SQL Reference)
ALTER TRIGGER statement (SQL Reference)
DISABLE option (Administrator's Guide)
ENABLE option (Administrator's Guide)
autonomous triggers (PL/SQL User's Guide and Reference)
BEFORE triggers (SQL Reference)
     [entry #2] (Concepts)
complex security authorizations (Application Developer's Guide - Fundamentals)
correlation names and (Application Developer's Guide - Fundamentals)
defined (Concepts)
derived column values (Application Developer's Guide - Fundamentals)
specifying (Application Developer's Guide - Fundamentals)
when fired (Concepts)
CREATE ANY TRIGGER system privilege (SQL Reference)
CREATE TRIGGER command (Application Developer's Guide - Fundamentals)
REFERENCING option (Application Developer's Guide - Fundamentals)
database triggers (Concepts)
     [entry #2] (Java Stored Procedures Developer's Guide)
     [entry #3] (PL/SQL User's Guide and Reference)
     [entry #4] (Java Stored Procedures Developer's Guide)
autonomous (PL/SQL User's Guide and Reference)
calling Java from (Java Stored Procedures Developer's Guide)
See also triggers (Concepts)
database triggers. (SQL Reference)
DBA_INTERNAL_TRIGGERS view (Reference)
DBA_TRIGGERS view (Reference)
DBA_TRIGGER_COLS view (Reference)
DROP ANY TRIGGER system privilege (SQL Reference)
DROP TRIGGER command (Application Developer's Guide - Fundamentals)
DROP TRIGGER statement (SQL Reference)
event triggers (Application Developer's Guide - Fundamentals)
INSTEAD OF trigger (Getting to Know Oracle8i)
INSTEAD OF triggers (SQL Reference)
     [entry #2] (Concepts)
     [entry #3] (Application Developer's Guide - Fundamentals)
nested tables (Concepts)
     [subentry #2] (Application Developer's Guide - Object-Relational Features)
object views (Concepts)
on nested table view columns (Application Developer's Guide - Fundamentals)
internal triggers (Replication)
login triggers (Application Developer's Guide - Fundamentals)
     [entry #2] (Application Developer's Guide - Fundamentals)
     [entry #3] (Application Developer's Guide - Fundamentals)
mutating errors and triggers (Concepts)
Oracle Forms triggers versus (Concepts)
oraRepDisabledTriggers variable (Enterprise Manager SNMP Support Reference Guide)
replication triggers (Replication)
row trigger (Java Stored Procedures Developer's Guide)
row triggers (Concepts)
defining (Application Developer's Guide - Fundamentals)
REFERENCING option (Application Developer's Guide - Fundamentals)
See also triggers (Concepts)
timing (Application Developer's Guide - Fundamentals)
UPDATE statements and (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
when fired (Concepts)
statement trigger (Java Stored Procedures Developer's Guide)
statement triggers (Concepts)
conditional code for statements (Application Developer's Guide - Fundamentals)
described (Concepts)
row evaluation order (Application Developer's Guide - Fundamentals)
See also triggers (Concepts)
specifying SQL statement (Application Developer's Guide - Fundamentals)
timing (Application Developer's Guide - Fundamentals)
trigger evaluation order (Application Developer's Guide - Fundamentals)
UPDATE statements and (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
valid SQL statements (Application Developer's Guide - Fundamentals)
when fired (Concepts)
triggers (Concepts)
     [entry #2] (Concepts)
     [entry #3] (Concepts)
     [entry #4] (Concepts)
     [entry #5] (PL/SQL User's Guide and Reference)
     [entry #6] (Utilities)
     [entry #7] (Data Warehousing Guide)
about (Application Developer's Guide - Fundamentals)
accessing column values (Application Developer's Guide - Fundamentals)
action (Concepts)
timing of (Concepts)
AFTER (SQL Reference)
     [subentry #2] (Application Developer's Guide - Fundamentals)
     [subentry #3] (Application Developer's Guide - Fundamentals)
     [subentry #4] (Application Developer's Guide - Fundamentals)
     [subentry #5] (Application Developer's Guide - Fundamentals)
auditing (Administrator's Guide)
     [subentry #2] (Administrator's Guide)
auditing with (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
autonomous (PL/SQL User's Guide and Reference)
BEFORE (SQL Reference)
     [subentry #2] (Application Developer's Guide - Fundamentals)
     [subentry #3] (Application Developer's Guide - Fundamentals)
     [subentry #4] (Application Developer's Guide - Fundamentals)
     [subentry #5] (Application Developer's Guide - Fundamentals)
body (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
     [subentry #3] (Application Developer's Guide - Fundamentals)
     [subentry #4] (Application Developer's Guide - Fundamentals)
check constraints (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
client events (Application Developer's Guide - Fundamentals)
column list in UPDATE (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
compatibility (Migration)
compiled (Application Developer's Guide - Fundamentals)
compiling (SQL Reference)
conditional predicates (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
CREATE TRIGGER ON (Application Developer's Guide - Fundamentals)
creating (SQL Reference)
     [subentry #2] (Application Developer's Guide - Fundamentals)
     [subentry #3] (Application Developer's Guide - Fundamentals)
     [subentry #4] (Application Developer's Guide - Fundamentals)
creating multiple (SQL Reference)
data access restrictions (Application Developer's Guide - Fundamentals)
database
altering (SQL Reference)
dropping (SQL Reference)
dropping (SQL Reference)
database insert (Utilities)
debugging (Application Developer's Guide - Fundamentals)
designing (Application Developer's Guide - Fundamentals)
disabling (Administrator's Guide)
     [subentry #2] (Application Developer's Guide - Fundamentals)
trigger evaluation order (Application Developer's Guide - Fundamentals)
use of LONG, LONG RAW (Application Developer's Guide - Fundamentals)
username reported in (Application Developer's Guide - Fundamentals)
WHEN clause (Application Developer's Guide - Fundamentals)
distributed query creation (Application Developer's Guide - Fundamentals)
     [subentry #2] (Distributed Database Systems)
dropped automatically when downgrading (Migration)
dropped tables and (Administrator's Guide)
     [subentry #2] (Application Developer's Guide - Fundamentals)
enabling (Administrator's Guide)
     [subentry #2] (Application Developer's Guide - Fundamentals)
error conditions and exceptions (Application Developer's Guide - Fundamentals)
event (Application Developer's Guide - Fundamentals)
events (Application Developer's Guide - Fundamentals)
examples (Administrator's Guide)
     [subentry #2] (Application Developer's Guide - Fundamentals)
     [subentry #3] (Application Developer's Guide - Fundamentals)
FOR EACH ROW clause (Application Developer's Guide - Fundamentals)
generating derived column values (Application Developer's Guide - Fundamentals)
illegal SQL statements (Application Developer's Guide - Fundamentals)
in tuning OLTP applications (Designing and Tuning for Performance)
INSTEAD OF triggers (Application Developer's Guide - Fundamentals)
object views and (Application Developer's Guide - Object-Relational Features)
integrity constraints vs. (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
internal (Replication)
listing information about (Application Developer's Guide - Fundamentals)
LOB columns with (Application Developer's Guide - Large Objects (LOBs))
login (Application Developer's Guide - Fundamentals)
     [subentry #2] (Application Developer's Guide - Fundamentals)
     [subentry #3] (Application Developer's Guide - Fundamentals)
migration issues (Application Developer's Guide - Fundamentals)
modifying (Application Developer's Guide - Fundamentals)
multiple same type (Application Developer's Guide - Fundamentals)
mutating tables and (Application Developer's Guide - Fundamentals)
naming (Application Developer's Guide - Fundamentals)
on DATABASE and SCHEMA (Getting to Know Oracle8i)
on nested table view columns (Getting to Know Oracle8i)
downgrading (Migration)
package variables and (Application Developer's Guide - Fundamentals)
permanently disabled (Utilities)
prerequisites before creation (Application Developer's Guide - Fundamentals)
privileges (Application Developer's Guide - Fundamentals)
to drop (Application Developer's Guide - Fundamentals)
privileges for enabling and disabling (Administrator's Guide)
replicating (Replication)
     [subentry #2] (Replication)
update
SQL*Loader (Utilities)
with CALL to a procedure as trigger body (Getting to Know Oracle8i)
with LOBs (Data Cartridge Developer's Guide)
USER_INTERNAL_TRIGGERS view (Reference)
USER_TRIGGERS view (Reference)
USER_TRIGGER_COLS view (Reference)
[Back to top]

Bibliography

The links on this page lead to many different books. This section lists PDF files that you can download and print, if you want to do further reading. This section also identifies the relevant chapters that you can print out, rather than printing the entire book.

PDF FileMajor Topics to Print
Administrator's Guide
  • Auditing Database Use
  • General Management of Schema Objects
  • Enabling and Disabling Triggers
Application Developer's Guide - Fundamentals
  • Using Triggers
  • Creating Triggers
  • INSTEAD OF Triggers
  • The Trigger Body
  • Restrictions on Creating Triggers
  • Compiling Triggers
  • Modifying Triggers
  • Enabling and Disabling Triggers
  • Examples of Trigger Applications
Application Developer's Guide - Large Objects (LOBs)
  • General
Application Developer's Guide - Object-Relational Features
  • Updating Object Views
Concepts
  • PL/SQL
  • Data Integrity
  • Triggers
  • Introduction to Triggers
  • How Triggers Are Used
  • Parts of a Trigger
  • Types of Triggers
  • Row Triggers and Statement Triggers
  • BEFORE and AFTER Triggers
  • INSTEAD OF Triggers
  • Triggers on System Events and User Events
  • Trigger Execution
  • Restrictions on Parallel DML
  • How Oracle Enforces Data Integrity
Designing and Tuning for Performance
  • Approaches to SQL Statement Tuning
Enterprise Manager SNMP Support Reference Guide
  • oraRepTable
Error Messages
Getting to Know Oracle8i
  • Glossary
Internet Directory Application Developer's Guide
  • Sample PL/SQL Usage
Java Stored Procedures Developer's Guide
  • Calling Stored Procedures
JavaServer Pages Developer's Guide and Reference
  • OracleJSP Support for Oracle SQLJ
Message Broker Administration Guide
  • Oracle Message Broker Configuration
  • Creating and Configuring Asynchronous Component Invocation Triggers
PL/SQL User's Guide and Reference
  • In the Oracle Server
  • Using Autonomous Transactions
  • Invoker Rights versus Definer Rights
Reference
  • Static Data Dictionary Views
Replication
  • Diagnosing Problems with Master Sites
Spatial User's Guide and Reference
  • B.5.1 Migrating from Spatial Release 8.1.5 to Release 8.1.6
SQL Reference
  • Basic Elements of Oracle SQL
  • ALTER TABLE
  • ALL TRIGGERS
  • ALTER TRIGGER
  • COMPILE
  • CREATE TRIGGER
  • call_procedure_statement
  • DROP TRIGGER
  • trigger
Utilities
  • Export Parameters
  • Case 7: Extracting Data from a Formatted Report
  • Database Insert Triggers
WebDB Tutorial Guide
  • Glossary

Oracle
Copyright © 2024, Oracle and/or its affiliates. All rights reserved.