From oracle-l-bounce@freelists.org Mon May 2 16:09:54 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j42L9sIR032132 for ; Mon, 2 May 2005 16:09:54 -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 j42L9s4Z032128 for ; Mon, 2 May 2005 16:09:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A508418FF3E; Mon, 2 May 2005 15:07:21 -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 24442-01; Mon, 2 May 2005 15:07:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 25D3018FF5B; Mon, 2 May 2005 15:07:21 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=P5BaAyAf+2PFgGIxqNvrK92IJpzW6uSBcTZ6IcvWIUvH5XG6yXwZLu+zgese0Rpcp/VAQSo5u7fZWbOqhKa3hUYGammHyvXbOpzyLU4r4k6Wrm4SDVmZjPKMSn7R6izNcfepX7L8EUhF8T2FbKLtCUUN021pjZl1Elq8NAIgMEw= Message-ID: Date: Mon, 2 May 2005 15:05:33 -0500 From: Bill Coulam To: rjamya@gmail.com Subject: Re: Quick compare of PL/SQL records Cc: jkstill@gmail.com, Oracle-L , ranko.mosic@gmail.com, Gints Plivna , gogala@sbcglobal.net In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: <367369f105042906013a719296@mail.gmail.com> <6e49b6d005042906141c10a75@mail.gmail.com> <367369f1050429062340b03837@mail.gmail.com> <1114783619l.12921l.1l@medo.noip.com> <9177895d0504290720548ab358@mail.gmail.com> X-archive-position: 19261 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bcoulam@gmail.com Precedence: normal Reply-To: bcoulam@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 And if you can actually force Oracle to let you define a PL/SQL record at the SQL level, then you've probably defiled your database as well. An object, on the other hand, can be defined at the SQL level, as in "CREATE OR REPLACE TYPE myobj AS OBJECT..." as shown in the examples above. To Ranko: If you can make it work, you could turn around and resell it ! On 4/29/05, Jared Still wrote: > PL/SQL records are only defiled when filtered through Java. > On 4/29/05, rjamya wrote: > > > > if the pl/sql records are defiled at sql level (i.e. type declaration > > rather > > than in packages), you probably can write a block of plsql that will ch= urn > > out the code to do comparison for you. > > >=20 > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist >=20 > -- > http://www.freelists.org/webpage/oracle-l >=20 --=20 bill coulam bcoulam@gmail.com -- http://www.freelists.org/webpage/oracle-l