Home
ROWID and UROWID data types should not be used
Rule description
- ROWID and UROWID data types should not be used
Non-compliant Code Example
DECLARE first_name varchar2; customer_id ROWID; --Non compliant code (ROWID data type is used) BEGIN UPDATE CUSTOMERS SET FIRSTNAME = first_name WHERE ROWID = customer_id; END;
Compliant Code Example
DECLARE first_name varchar2; customer_id INTEGER; --Compliant code BEGIN UPDATE CUSTOMERS SET FIRSTNAME = first_name WHERE ROWID = customer_id; END;