How to: |
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:
Allows you to replace a synonym that already exists, without having to issue a DROP synonym command (optional).
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).
Is the name of the appropriate schema. If this phrase is omitted, Oracle assumes that you are referring to your own schema.
Is the name of the public synonym you are creating.
Is the name of the object for which you are creating the synonym.
For example:
create public synonym suppliers for app.suppliers;
To locate a package and view the Oracle E-Business Suite stored procedures it contains:
The Find dialog box opens.
Note: Packages are collections of stored procedures. Due to the large number of packages and stored procedures available, a search capability is provided. You can search for a particular package by typing the full package name into the Named field, as shown in the preceding image. Alternatively, you can search for package names beginning with a certain string, for example, typing FND% generates a list of all package names starting with the string FND. This search capability is not case sensitive.
A list of the stored procedures contained in this package is displayed in the left pane.
You can now generate schemas and create iWay Business Services for packages.