Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: V. Urgent - Got Stuck with trigger
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;
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
What are the other solutions ??
(Do not execute this trigger on ur side. if u don't know the solution)
Thx & Regards,
Sam
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).
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). Received on Mon Jul 22 2002 - 02:23:21 CDT
![]() |
![]() |