Re: Quick compare of PL/SQL records
- From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
- To: Bill Coulam <bcoulam@xxxxxxxxx>
- Date: Fri, 13 May 2005 12:21:35 -0400
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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
> > PL/SQL records are only defiled when filtered through Java.
> > On 4/29/05, rjamya <rjamya@xxxxxxxxx> 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
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>=20
> --
> bill coulam
> bcoulam@xxxxxxxxx
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
