Re: Possible to compare two variables of type %ROWTYPE?

On Wed, 26 Nov 2003 13:09:00 +0100, "Randi Wølner" <randiwolner_at_hotmail.com> wrote:

>Oracle 8.1.7: Is it possible in PL/SQL to compare two variables of type
>%ROWTYPE to each other? I wished to do something like this:
>
>
>If ExistRow<>NewRow THEN ...

Can't compare the records directly. You can hide the field-to-field comparisons inside a user-written function:

IF rows_equal(ExistRow,NewRow) THEN ...

John

--
Photo gallery: http://www.pbase.com/john_russell/