ALTER TRIGGER in a PL SQL CODE

[Kalyan Ganesan]

I want a code like this to work


BEGIN

ALTER TRIGGER SCEHEMA.TEST_UPDATE_TRG DISABLE;

EXCEPTION
WHEN OTHERS
THEN
WHEN OTHERS
THEN
err_num := SQLCODE;
err_msg := SUBSTR (SQLERRM, 1, 100);
err_loc := 'TEST_UPDATE_TRG';
err_date := SYSDATE;

INSERT INTO ERRORS
VALUES (err_num, err_msg, err_loc, err_date);
END ;


But i get this error below

ORA-06550: line 3, column 4:
PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:

( begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback

How to fix it..

 

[johnherman]

example at:

https://stackoverflow.com/questions...sable-a-trigger-in-an-oracle-stored-procedure

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity