Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Possible to compare two variables of type %ROWTYPE?
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