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).