Re: Quick compare of PL/SQL records

From: Bill Coulam <bcoulam_at_gmail.com>
Date: Mon, 2 May 2005 15:05:33 -0500
Message-ID: <f51d3302050502130560a0de7a@mail.gmail.com>

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 <jkstill_at_gmail.com> wrote:
> PL/SQL records are only defiled when filtered through Java.
> On 4/29/05, rjamya <rjamya_at_gmail.com> 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_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 02 2005 - 16:09:54 CDT