Re: Trigger question

From: David Sisk <davesisk_at_travelin.com>
Date: 1998/02/15
Message-ID: <6c7ns5$t5m$1@lal.interserv.com>#1/1

Even DDL statements using DBMS_SQL are disallowed in a trigger. Any DDL statements are disallowed in triggers because they implicitly issue a COMMIT. Good luck,
Dave

Rajan Muthiah wrote in message <34E49EA0.71FB_at_abbott.com>...
>Larry Schenavar wrote:
>>
>> Can you execute the 'ALTER USER' statement in trigger body?
>>
>> --
>> ==============================
>> Larry Schenavar
>> Infrastructure Specialist /DB
>> Electronic Data Systems, Inc
>>
>> Email: schenavar_at_northstate.net
>> ==============================
>Hi,
> Use DBMS_SQL in a stored procedure. I have used it for password
>change
>procedures.
>Rajan
Received on Sun Feb 15 1998 - 00:00:00 CST