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

RE: V. Urgent - Got Stuck with trigger

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

Re: V. Urgent - Got Stuck with trigger

sam d£¬ hei, it is easy, logon as osuser and drop the trigger, it is ok. I tested it on my 920 on linux: SQL CREATE OR REPLACE TRIGGER tpp 2before alter or create or drop on database 3 declare 4 uname varchar2(20); 5 begin 6 select username into

V. Urgent - Got Stuck with trigger

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