Browsing Oracle API Metadata

Oracle E-Business Suite supports PL/SQL blocks, package. A package is a PL/SQL construct that allows related objects to be stored together. The adapter is able to expose all the packages and interact with its stored procedure element. In the iWay Application Adapter for Oracle E-Business Suite, packages are categorized by the schema that owns the object. Using iWay Explorer, you can search for specific packages and specific stored procedures under a package.

Note: If you do not see a package under a schema, you may need to create a public synonym. An Oracle DBA may use the following syntax:

create [or replace] [public] synonym schema.synonym_namefor schema.object_name [@ dblink]; 

where:

or replace

Allows you to replace a synonym that already exists, without having to issue a DROP synonym command (optional).

public

Indicates that the synonym is a public synonym and is accessible to all users. You must have the appropriate privileges to the object to use the synonym (optional).

schema

Is the name of the appropriate schema. If this phrase is omitted, Oracle assumes that you are referring to your own schema.

synonym_name

Is the name of the public synonym you are creating.

object_name

Is the name of the object for which you are creating the synonym.

For example:

create public synonym suppliers
for app.suppliers;