Try to disable the trigger first then drop it.
The error is expected because the SQL in trigger will return more than one
row.
HTH
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).
