EXEC pROCEDURE IN TRIGGER 2005-06-29 - By Kean Jacinta
i GOT THIS ERROR ORA-04092 (See ORA-04092.ora-code.com): 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@(protected)> 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@(protected)
> [mailto:oracle-l-bounce@(protected)] On Behalf Of
> Kean Jacinta
> Sent: 29 June 2005 09:52
> To: oracle-l@(protected)
> 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
|
|
