Re: Trigger question

From: Rajan Muthiah <Rajan.Muthiah_at_abbott.com>
Date: 1998/02/13
Message-ID: <34E49899.3A98@abbott.com>#1/1

Matthias Gresz wrote:
>
> On Tue, 10 Feb 1998 16:41:54 -0500, "Larry Schenavar" <schenavar_at_northstate.net>
> wrote:
> Hi Larry,
>
> since 'ALTER..' issues a 'COMMIT' implicitely, it isn't allowed in database
> triggers. You might use it with Form triggers.
>
> --
> Regards
> Matthias Gresz :-)
>
> >Can you execute the 'ALTER USER' statement in trigger body?
> >
> >--
> >==============================
> >Larry Schenavar
> >Infrastructure Specialist /DB
> >Electronic Data Systems, Inc
> >
> >Email: schenavar_at_northstate.net
> >==============================
> >
> >
>
> --
>
> Regards
>
> Matthias Gresz :-)

Hi!

To change password I tried to FORMS_DDL and didn't succeed. I ended up using DBMS_SQL in a stored procedure. (of course to issue an Alter User statement).
Good luck
Rajan Received on Fri Feb 13 1998 - 00:00:00 CST