Every constant, variable, parameter, and function return value in PL has a data type that defines its storage format, use limits, valid value range, and valid operations.
In OceanBase Database, PL predefines a variety of data types and allows you to define custom data types.
PL predefined data types include:
SQL data types
BOOLEAN
REF cursor
User-defined types
PLS_INTEGERandBINARY_INEGER
Notice
BOOLEAN,RECORD,REF CURSOR, and some predefined subtypes are specific to PL.- You cannot use such PL-specific data types in standalone subprograms at the schema level. You need to put the subprogram into a package so as to use these data types.