E ed10k Member² Jul 20, 2007 #1 Code: CREATE OR REPLACE TRIGGER TRUNC_TRG BEFORE TRUNCATE ON SCHEMA BEGIN RAISE_APPLICATION_ERROR(-20999,'UNABLE TO TRUNCATE'); END; Then right-click on TRUNC_TRG and select "Browse" at context-menu. ERROR: "Object is not available in the browser"
Code: CREATE OR REPLACE TRIGGER TRUNC_TRG BEFORE TRUNCATE ON SCHEMA BEGIN RAISE_APPLICATION_ERROR(-20999,'UNABLE TO TRUNCATE'); END; Then right-click on TRUNC_TRG and select "Browse" at context-menu. ERROR: "Object is not available in the browser"
Marco Kalter Administrator Staff member Jul 20, 2007 #1 Apparently it incorrectly searches the trigger under the Tables folder. We'll fix it.