5.9 Managing Methods on Tables

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:

  1. On the Workspace home page, click the SQL Workshop.
  2. Click Utilities.
  3. Click Methods on Tables.

    The Create Table API page appears.

  4. 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.
  5. Select the table(s) for which you want to generate the PL/SQL package-based application program interface (API) and click Next.
  6. 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.