Re: ALTERing triggers from within a trigger
From: Bblount <bblount_at_aol.com>
Date: 1995/09/29
Message-ID: <44gb4h$p6j_at_newsbf02.news.aol.com>#1/1
Date: 1995/09/29
Message-ID: <44gb4h$p6j_at_newsbf02.news.aol.com>#1/1
Hi Scott,
In the PL/SQL User's Guide And Reference, page 4-2 is the following:
"...PL/SQL supports all SQL data manipulation commands (except EXPLAIN
PLAN), transaction control commands, functions, pseudocolumns, and
operators.
However, PL/SQL does NOT support data definition commands such as
CREATE, session control commands such as SET ROLE, or the system
control command ALTER SYSTEM."
ALTER TRIGGER falls into the data definition category (see page 4-4 of the
Oracle7 SQL Language Reference Manual).
Hope that helps,
Bill Blount
Staff Instructor
Oracle Corp.
wblount_at_us.oracle.com
Received on Fri Sep 29 1995 - 00:00:00 CET