The Managing Methods on Tables utility enables you to create an application programming interface, or package, based on a specified table.
To create a package:
- On the Workspace home page, click the SQL Workshop.
- Click Utilities.
- Click Methods on Tables.
The Create Table API page appears.
- Enter a Package name. To have the final package name match the case entered in the Package Name field, click Preserve Case and click Next.
- Select the table(s) for which you want to generate the PL/SQL package-based application program interface (API) and click Next.
- A confirmation page appears, which displays the subprogram(s) and their description. You have the option to show or download the specification or body. To confirm, click Create Package.