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