Home » SQL & PL/SQL » SQL & PL/SQL » row_id wrong type in trigger (Toad , pl/sql)
row_id wrong type in trigger [message #314460] Wed, 16 April 2008 15:41 Go to next message
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;
Re: row_id wrong type in trigger [message #314473 is a reply to message #314460] Wed, 16 April 2008 17:16 Go to previous message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The ROWID has the ROWID datatype.

Concept Manual

Previous Topic: Foreign key constraints mapping
Next Topic: Logic trouble
Goto Forum:
  


Current Time: Thu Feb 13 11:05:13 CST 2025