From oracle-l-bounce@freelists.org Mon Dec 13 08:15:19 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iBDEFJP10751 for ; Mon, 13 Dec 2004 08:15:19 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iBDEFJ010746 for ; Mon, 13 Dec 2004 08:15:19 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4923C72CB77; Mon, 13 Dec 2004 09:21: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 03706-11; Mon, 13 Dec 2004 09:21:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B9DB72CBBA; Mon, 13 Dec 2004 09:19:57 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=wu5jAML5enEWK0zDvMjaYJqtcZTsH4LMJ5Q/EQCDBrviQOxYvevEP1m2ygQrkNlPAJBAObu5WhoTckFKnsBhbMwOISEl/fO+1vw7IUpUW+IDKFD8O8YEDuWNZ3Zjy7oOJlzcfvB9+65rwJAkUa0LdhgkgDfoE2Y1RUHruwlK5zE= ; Message-ID: <20041213141703.73206.qmail@web52609.mail.yahoo.com> Date: Mon, 13 Dec 2004 06:17:03 -0800 (PST) From: Martic Zoran Subject: Re: Find out the table name inside the trigger code To: "'Oracle-L Freelists'" In-Reply-To: <12305.145.61.28.21.1102946221.squirrel@145.61.28.21> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 13542 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zoran_martic@yahoo.com Precedence: normal Reply-To: zoran_martic@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Carel-Jan, Thanks a lot. Of course I am doing exactly what you said. Using PL/SQL for the code and passing the table name to the PL/SQL from the triggers. With ora_sql_text I can eliminate even that parameter, but the benefit is not going to be the great. It just popup in the head today. He asked me and I did not know. Try to find it and could not (limited time :) Then I asked it here. Regards, Zoran Martic --- Carel-Jan Engel wrote: > Zoran, > > When you have very similar code, and it is 'copied' > into a number of > triggers, consider putting the code in a packaged > procedure, and call this > from your trigger. hard-coding (generating) the > triggers is getting more > straightforward then. And you can pass the tablename > in the call, > hardcoded (and generated). > > It gives you one central point for maintenance, in > stead of changing lots > of triggers (and forgetting one every now and then). > > Regards, Carel-Jan > > === > If you think education is expensive, try ignorance. > (Derek Bok) > === __________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com -- http://www.freelists.org/webpage/oracle-l