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: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The ROWID has the ROWID datatype.

Concept Manual

Previous Topic: Need sql to create test data , already searched the old posts
Next Topic: ORA-27041: unable to open file SVR4 Error: 24: Too many open files ...
Goto Forum:

Current Time: Mon Aug 21 03:32:40 CDT 2017

Total time taken to generate the page: 0.01368 seconds