Re: Quick compare of PL/SQL records

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Fri, 13 May 2005 12:21:35 -0400
Message-ID: <367369f10505130921482ce64@mail.gmail.com>

Ended up creating a function with input parameters ( source ) which select= s
from target table.=20

Thanks all.rm.=20

On 5/2/05, Bill Coulam <bcoulam_at_gmail.com> wrote:
> 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.

>=20

> 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.

>=20

> To Ranko: If you can make it work, you could turn around and resell it !

>=20

> 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 =
churn
> > > out the code to do comparison for you.
> > >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >

>=20

> --
> bill coulam
> bcoulam_at_gmail.com

>

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

Received on Fri May 13 2005 - 12:26:08 CDT