This reference documentation contains information about PL/SQL API packages that are available with Oracle9iAS Portal Developer Kit (PDK). The table below shows the PL/SQL API packages that are available. To find out more, click on the links in the table below.

Granting permissions to execute the PL/SQL APIs:

When using the PL/SQL APIs to build portlets or to perform actions on your portal, you will need to run the provsyns.sql script. This script grants permissions to your schema to execute the PL/SQL APIs and needs to be run once before creating any PL/SQL portlets or procedures in a schema.

You can find provsyns.sql under your IAS_HOME/portal/admin/plsql/wwc in 9.0.x and IAS_HOME/portal30/webdb30/admin/plsql/wwv in 3.0.x

For example: /9iAS_MID/portal/admin/plsql/wwc

Log into SQL*Plus as the portal schema and run the script:

    SQL>@provsyns.sql <myschema>

Where "myschema" is the name of the schema where your portlets and proceudres will reside.