G-2320: Avoid using VARCHAR data type.

Major

Portability

Reason

Do not use the VARCHAR data type. Use the VARCHAR2 data type instead. Although the VARCHAR data type is currently synonymous with VARCHAR2, the VARCHAR data type is scheduled to be redefined as a separate data type used for variable-length character strings compared with different comparison semantics.

Example (bad)

1
2
3
4
create or replace package types is
   subtype description_type is varchar(200 char);
end types;
/

Example (good)

1
2
3
4
create or replace package types is
   subtype description_type is varchar2(200 char);
end types;
/