Manual says: Comparing Records Records cannot be tested for nullity, or compared for equality, or inequali= ty. If you want to make such comparisons, write your own function that accepts two records as parameters and does the appropriate checks or comparisons on the corresponding fields. http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10807/05_coll= s.htm#i20716 On 4/29/05, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote: > How do I compare two separatelly defined PL/SQL records without > referencing each and every field ? >=20 > source_rec source_table%rowtype; > source1_rec source1_table%rowtype; >=20 > Thanks, Ranko. -- //www.freelists.org/webpage/oracle-l