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
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
l_orig_rowid number;
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;
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
Messages: 3186
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: Mon Oct 24 08:17:31 CDT 2016

Total time taken to generate the page: 0.08867 seconds