A package is a collection of related PL programming elements, such as functions, procedures, variables, and cursors. It is similar to a Java class, where variables are like member variables, and functions and procedures are like methods. The main purpose of a package is to group similar items to simplify maintenance and management, which improves developer efficiency and performance.
OceanBase Database V2.2.20 and later versions support creating trigger objects in Oracle mode. This feature is not yet supported in MySQL mode.
In OceanBase Developer Center (ODC), after you open a connection in Oracle mode, click the Packages tab in the navigation pane on the left to view the package list. Double-click a package name in the list to open the package management page. This page displays the basic information and code for the package specification and body.
This chapter describes the following operations on package objects in ODC: