row_id wrong type in trigger [message #314460] |
Wed, 16 April 2008 15:41  |
deahayes3
Messages: 203 Registered: May 2006
|
Senior Member |

|
|
simple question I hope, I am trying to set a variable equal to row_id what is the datatype? I put number and it says wrong type
See below
DECLARE
l_orig_rowid number;
BEGIN
IF :NEW.product_type = 'PAINT'THEN
l_orig_rowid := :NEW.ROWID;--says wrong type here UPDATE my_table
SET deq_cc = :NEW.deq_cc,
date_of_use = :NEW.date_of_use
WHERE product_type != 'PAINT'
AND ROWID <> l_orig_rowid;
END IF;
|
|
|
|