Help Center/ GaussDB/ Service Overview/ Compatibility with Oracle/ Distributed Instances/ PL/SQL Language/ Data Type Compatibility
Updated on 2024-05-14 GMT+08:00
View PDF

Data Type Compatibility

Table 1 Other PL/SQL data types

No.

Oracle

GaussDB

Difference

1

CHARACTER

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

2

VARCHAR

Supported, with differences.
  • GaussDB: The length ranges from 1 to 10485760 bytes.
  • Oracle: 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.

5

BINARY_INTEGER

Supported.

-
Parent topic: PL/SQL Language