RE: EXEC pROCEDURE IN TRIGGER

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Wed, 29 Jun 2005 10:59:11 +0100
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63030F0C3B@UKWMXM04>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 29 2005 - 06:04:43 CDT