From oracle-l-bounce@freelists.org Tue Jan 11 14:38:24 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0BKcOJ01776 for ; Tue, 11 Jan 2005 14:38:24 -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 j0BKcOn01771 for ; Tue, 11 Jan 2005 14:38:24 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 65F0F72C384; Tue, 11 Jan 2005 15:45:00 -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 20812-68; Tue, 11 Jan 2005 15:45:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 459E772C6D8; Tue, 11 Jan 2005 15:41:47 -0500 (EST) Message-ID: X-Originating-IP: [204.101.196.18] X-Originating-Email: [ganstadba@hotmail.com] X-Sender: ganstadba@hotmail.com From: "Michael McMullen" To: , References: <011120052019.3479.41E434D6000B14DD00000D972205886014CDA10A02070B040E9D0A09@comcast.net> Subject: Re: substitute object name with bind variables Date: Tue, 11 Jan 2005 15:35:49 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-OriginalArrivalTime: 11 Jan 2005 20:37:00.0777 (UTC) FILETIME=[4D4BCD90:01C4F81D] X-archive-position: 14631 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ganstadba@hotmail.com Precedence: normal Reply-To: ganstadba@hotmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org It won't work, oracle will puke. It won't be able to resolve what :b1 corresponds to which object and throw out an error. Now you may have just given an example but you don't need execute immediate for a delete. Mike -- http://www.freelists.org/webpage/oracle-l