From oracle-l-bounce@freelists.org Mon Aug 22 16:38:42 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7MLcg0i028216 for ; Mon, 22 Aug 2005 16:38:42 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7MLcSIP028180 for ; Mon, 22 Aug 2005 16:38:32 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 51B2C1E59F8; Mon, 22 Aug 2005 16:37:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23451-02; Mon, 22 Aug 2005 16:37:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C0E2B1E59BA; Mon, 22 Aug 2005 16:37:44 -0500 (EST) From: "David Wendelken" To: "'Oracle-L@Freelists. Org (E-mail)'" Subject: RE: Debug DDL trigger Date: Mon, 22 Aug 2005 17:39:37 -0400 Organization: CASEtech, Inc. Message-ID: <002d01c5a761$fee4f010$6401a8c0@davidwendelken> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002E_01C5A740.77D35010" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: AAAAAORZ18h9lqdCtv4yP58C4dCE10oA X-archive-position: 24316 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: davewendelken@earthlink.net Precedence: normal Reply-To: davewendelken@earthlink.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.8 required=5.0 tests=AWL,BAYES_00,HTML_70_80, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_002E_01C5A740.77D35010 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I'm guessing ora_dict_obj_type is a column in dherri.schema? If so, you are using row-level data in a statement-level trigger. You need to add the magic words that turn the trigger into a row level trigger. It's "for each row" or words to that effect. You'll find the exact syntax in the manual. Here's the trigger's text: CREATE OR REPLACE TRIGGER sys.cp_tab_before_drop_btg BEFORE drop ON dherri.SCHEMA WHEN ( ora_dict_obj_type = 'TABLE' AND ( ora_dict_obj_name LIKE 'SCORE\_ACCT\_TB\_%' ESCAPE '\' ) ) ------=_NextPart_000_002E_01C5A740.77D35010 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
 
I'm=20 guessing ora_dict_obj_type is a column in=20 dherri.schema?
 
If so, = you are using=20 row-level data in a statement-level trigger.
You=20 need to add the magic words that turn the trigger into a row level=20 trigger.
It's=20 "for each row" or words to that effect.  You'll find the exact = syntax in the manual.
 
 
Here's the trigger's=20 text:

 

CREATE OR REPLACE = TRIGGER=20 sys.cp_tab_before_drop_btg

   BEFORE drop = ON=20 dherri.SCHEMA

     =20 WHEN (    ora_dict_obj_type =3D=20 'TABLE'

           = =20 AND (   ora_dict_obj_name LIKE 'SCORE\_ACCT\_TB\_%' ESCAPE=20 '\'

           =     =20 )

          =20 )

 

------=_NextPart_000_002E_01C5A740.77D35010-- -- http://www.freelists.org/webpage/oracle-l