Package alias

Package aliases are needed for all PL/SQL functions called from a URL (like a custom save from a form).

Properties

This section describes the properties of a package alias, as shown on the corresponding Edit pane.

Property Description
Subsystem

Select the subsystem the profile belongs to

Procedure name

Type the PL/SQL command that you want to call from the iKnowBase Oracle database. Use the syntax <package>.<procedure>, or <owner>.<package>.<procedure> if the package is owned by another schema than iKnowBase.

Alias Name

Type the alias of the database function.

iKnowBase alias

If checked, the procedure is a part of iKnowBase and should be untouched.

View the state of the procedure

This section will show info about the procedure as object type, status, created date and last DDL time.

View the signature of the procedure

This section will show the signature of the procedure