Log on to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click Program Package in the left-side navigation pane to get a list of program packages. To create a program package, click + in the upper-right corner of the program package list or click Create in the navigation bar on the top of the page. To create a program package, you need to create the package header and the package body.
Create the package header
Click the + icon in the upper-right corner of the package list, or click Create in the navigation bar to go to the Create Program Package page, where you can create the package header.
On the package creation page, specify the package name and click Next: Verify SQL Statement to go to the header definition page.
ODC automatically generates the template statement, as shown in the following figure. In the navigation bar of the header definition page, ODC provides the Format button for you to standardize the statement format. After you complete the header definition statements, click Create in the upper-right corner to generate the header.
Create the package body
After you create the package header, the new program package appears in the program package list. Right-click the created program package and click Create Package Body to go to the package body definition page. This page is similar to the header definition page, as shown in the following figure. ODC automatically generates the template statement and provides the Format button for you to standardize the statement format. After you complete the package body definition statements, click Create in the upper-right corner to generate the package body.