Oracle-L: RE: V. Urgent - Got Stuck with trigger

From: G Sanjay <g_sanjay_at_mks.panasonic.com.sg>
Date: Sun, 21 Jul 2002 23:43:19 -0800
Message-ID: <F001.0049D7A5.20020721234319@fatcity.com>

Just realized that alter table disable trigger will not work too.. Even if there is only one session on server it will return more than one row because of BG processes.

Sanjay

-----Original Message-----
Sent: 22 July, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L

Hi List,
My friend has foll.(Big)problem.

He'was testing the following trigger n now stuck. Do not execute this trigger on ur side.

CREATE OR REPLACE TRIGGER tpp

before alter or create or drop on database declare

uname varchar2(20);
begin

       select osuser into uname from v$session;
       if uname != 'Sachin' then
          raise_application_error(-20002,'not
allowed);
       end if;

end;

Now he can't modify/drop this trigger, He gets the follow error:
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4

One thing I suggested is to make sure
that there is only one session on server. Is that possible ?

What are the other solutions ??

(Do not execute this trigger on ur side. if u don't know the solution)

Thx & Regards,
Sam

Do You Yahoo!?
Yahoo! Health - Feel better, live better http://health.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: sam d
INET: sam_orafan_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: G Sanjay
INET: g_sanjay_at_mks.panasonic.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------