RE: EXEC pROCEDURE IN TRIGGER

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 29 Jun 2005 03:22:17 -0700 (PDT)
Message-ID: <20050629102218.24208.qmail@web52907.mail.yahoo.com>

i GOT THIS ERROR ORA-04092: cannot COMMIT in a trigger

I did not have any commit,execute in the trigger. Its just the procedure i am calling have this EXECUTE IMMEDIATE.

• "Hallas, John, Tech Dev" <John.Hallas_at_gb.vodafone.co.uk> wrote:

> What failures message do you get JK
>
> It is possible and here is part of an old post that
> shows it in use
>
> --create_LOGON_MULTIPLE_CHECK.sql
> CREATE OR REPLACE TRIGGER LOGON_MULTIPLE_CHECK
> AFTER logon ON DATABASE
> DECLARE
> client_info_str V$SESSION.CLIENT_INFO%TYPE;
> var_username V$SESSION.USERNAME%TYPE := null;
> kill_Login EXCEPTION;
> PRAGMA EXCEPTION_INIT( kill_Login, -20997 ); begin
> -- Set information string to uniquely identify this
> session
> client_info_str := 'Logon_Trigger_' ||
> LTRIM(dbms_random.value,'.');
> -- Push information string into v$session
>

>
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str);
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Kean Jacinta
> Sent: 29 June 2005 09:52
> To: oracle-l_at_freelists.org
> Subject: EXEC pROCEDURE IN TRIGGER
>
> Hi,
>
> Would it be possible to execute my procedure in
> trigger ?
>
> I have created a test procedure name : testproc
>
> I can execute this testproc in sql/plus by issue
> this
> command
>
> sql:> exec testproc('abc'); -- no problem
>
> I thought of calling this from trigger body, is that
> possible ?
>
> example in trigger abc_trg
>
> Begin
> exec testproc('abc');
> end;
>
> I tried ... got error. Wonder if this is possible.
>
> Thank in Advanced
>
> Cheers
> JK
>
>
>
> ____________________________________________________
>
> Yahoo! Sports
> Rekindle the Rivalries. Sign up for Fantasy Football
>
> http://football.fantasysports.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 29 2005 - 06:27:39 CDT