Re: What is wrong with this????
- From: Noons <wizofoz2k@xxxxxxxxxxxx>
- Date: Wed, 30 Jan 2008 18:21:45 -0800 (PST)
On Jan 31, 12:41 pm, Boogha <boo...@xxxxxxxxx> wrote:
I am trying to write a simple script to drop triggers for a user on a
10g database
declare
v_trgname varchar2(30);
v_dropstmt varchar2(60);
cursor c_triggers is
select trigger_name from user_triggers
where trigger_name not like 'TRG_%';
begin
open c_triggers;
loop
fetch c_triggers into v_trgname;
exit when c_triggers%notfound;
v_dropstmt := 'DROP TRIGGER ' || v_trgname;
execute immediate v_dropstmt;
end loop;
close c_triggers;
end;
As you can see there is no rocket science in the script. When I run
the script I get the following error:
Error at line 4
ORA-00933: SQL command not properly ended
ORA-06512: at line 13
Can anyone help, also the user has the permission to drop indexes
are u sure you not getting nulls into v_trgname
via the feed cursor?
.
- References:
- What is wrong with this????
- From: Boogha
- What is wrong with this????
- Prev by Date: Re: What is wrong with this????
- Next by Date: What is the best backup method, using RMAN, for backing up the physical and standby database?
- Previous by thread: Re: What is wrong with this????
- Next by thread: What is the best backup method, using RMAN, for backing up the physical and standby database?
- Index(es):
Relevant Pages
|
