Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Possible to compare two variables of type %ROWTYPE?

Possible to compare two variables of type %ROWTYPE?

From: Randi Wølner <randiwolner_at_hotmail.com>
Date: Wed, 26 Nov 2003 13:09:00 +0100
Message-ID: <bq259t$a8$1@services.kq.no>


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

But - this results in an error message (PLS-00306:wrong number or types of arguments in call to TO_CHAR.
Do I have to list every column in the row, like this: IF (ExistRow.ID <> NewRow.ID)
  OR (ExistRow.col1 <> NewRow.col1)
  OR (ExistRow.col2 <> NewRow.col2)
.
.
.

Thanks for any help!
Randi W. Received on Wed Nov 26 2003 - 06:09:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US