Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger question
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 :-)
DBMS_SQL in a stored procedure will work
Rajan
Received on Fri Feb 13 1998 - 00:00:00 CST
![]() |
![]() |