Re: -EXECUTE on oracle 8.0.0

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: Mon, 23 Jun 2003 15:18:58 +0000
Message-ID: <3033496.1056381538@dbforums.com>

Originally posted by Andre
> Hello all, I have written a pl/sql script. In the script I am
> disabling a trigger using the execute immediate function. But, the
> database on which I have to perform this is a oracle 8.0.0 version,
> which does not use execute immediat commands. I have to use something
> like dmbs_sql ?
>
> Does anyone know How to disable a trigger using the dbms_sql
> command???
>
> Thanks in advange,
> Andre van Rossem
> The Netherlands

SQL> create table foo (t number);

Table created.

SQL> create or replace trigger foo_trig
  2 before insert on foo for each row
  3 begin
  4 null;
  5 end foo_trig;
  6 /

Trigger created.

SQL> select status from user_triggers where trigger_name = 'FOO_TRIG';

STATUS

---

ENABLED SQL> declare

  2     cur_       integer;
  3     dummy_ integer;
  4  begin
  5     cur_ := dbms_sql.open_cursor;
  6     dbms_sql.parse(cur_, 'alter trigger foo_trig disable',
  dbms_sql.native);
  7     dummy_ := dbms_sql.execute(cur_);
  8     dbms_sql.close_cursor(cur_);

  9* end;
SQL> / PL/SQL procedure successfully completed.

SQL> select status from user_triggers where trigger_name = 'FOO_TRIG';

STATUS

---

DISABLED Regards
/Rauf Sarwar

--
Posted via http://dbforums.com

Received on Mon Jun 23 2003 - 10:18:58 CDT