Help Center/ GaussDB/ Compatibility(Distributed)/ Oracle Compatibility Description/ PL/SQL Language/ Data Type Compatibility
Updated on 2025-08-22 GMT+08:00
View PDF

Data Type Compatibility

Table 1 Other PL/SQL data types

No.

Oracle Database

GaussDB

Difference

1

CHARACTER

Supported, with differences.
  • GaussDB: The length ranges from 1 to 10485760 bytes.
  • Oracle Database: The length ranges from 1 to 32767 bytes.

2

VARCHAR

Supported, with differences.
  • GaussDB: The length ranges from 1 to 10485760 bytes.
  • Oracle Database: The length ranges from 1 to 32767 bytes.

3

STRING

Not supported.

-

4

PLS_INTEGER

Not supported.

In GaussDB, you can use the INT type instead.

5

BINARY_INTEGER

Supported.

-
Parent topic: PL/SQL Language