Log in 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.
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.
