When I do create script from a disable trigger, the keyword DISABLE is not on the good place. For example,
BAD sample
CREATE OR REPLACE TRIGGER APPS.TEST
AFTER INSERT
ON po_releases_all
FOR EACH ROW
WHEN (
UPPER(new.authorization_status) = 'APPROVED'
)
DISABLE
DECLARE
/* ARCS: $Header: itgoutev.sql 115.18 2005/05/13 07:13:15 bsaratna noship $
* CVS: itgoutev.sql,v 1.36 2003/09/04 18:54:53 ecoe Exp
*/
CURSOR get_doc(p_po_header_id NUMBER) IS
SELECT segment1
FROM po_headers_all
....
Good sample
CREATE OR REPLACE TRIGGER APPS.TEST
AFTER INSERT
ON po_releases_all
FOR EACH ROW
DISABLE
WHEN (
UPPER(new.authorization_status) = 'APPROVED'
)
DECLARE
/* ARCS: $Header: itgoutev.sql 115.18 2005/05/13 07:13:15 bsaratna noship $
* CVS: itgoutev.sql,v 1.36 2003/09/04 18:54:53 ecoe Exp
*/
CURSOR get_doc(p_po_header_id NUMBER) IS
SELECT segment1
FROM po_headers_all
....
The DISABLE should come before the WHEN clause.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center