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 -- //www.freelists.org/webpage/oracle-l