Re: Trigger Question

On Tue, 10 Feb 1998 11:47:22 -0500, "Larry Schenavar" <schenavar_at_northstate.net> wrote:

>Can I use 'ALTER USER' in the PL/SQL Body of a trigger?

Hi Larry,

if you mean a database trigger, you cannot. ALTER USER is a DDL statement that could be executed by DBMS_SQL, but DDL statements implicitely commit the current transaction and this is not allowed in database triggers.

HTH
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net