RE: EXEC pROCEDURE IN TRIGGER
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 29 Jun 2005 03:22:17 -0700 (PDT)
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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Kean Jacinta
> Sent: 29 June 2005 09:52
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
