Home

Deprecated LONG and LONG RAW datatypes should no longer be used

Rule description

  • Deprecated LONG and LONG RAW datatypes should no longer be used

 

Non-compliant Code Example

Create TABLE EMPLOYEE
(
  EMP_ID number(10) NOT NULL,
  FIRSTNAME NVARCHAR2(75),
  LASTNAME NVARCHAR2(75),
  DEPT_ID int,  
  ADDRESS NOT NULL,
  Landmark LONG RAW,            --Non compliant code (Column is of type Long Raw)
  Photo blob(),

  CONSTRAINT pk_employee PRIMARY KEY (EMP_ID)
);
Visual Expert 2020
 VEPLSQLRULE99