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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
