Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B32519-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

PL/SQL Functions dialog: Functions tab

Use this dialog to manage PL/SQL functions available to Discoverer Administrator. To register functions, you can:

For more information, see:

"Why do you need PL/SQL functions?"

"How to register custom PL/SQL functions automatically"

"How to register custom PL/SQL functions manually"


This field displays a list of Oracle-supplied PL/SQL functions and user-defined PL/SQL functions that have already been registered for use with Discoverer Administrator. When the Available in Discoverer Plus check box is selected, these registered functions are also available to Discoverer end users to use in calculations.

Attributes for <function selected in Functions field>

This area displays information about the selected PL/SQL function.

Function Name

Use this field to enter a name for the function. The Function Name can be different from the Display Name.

Display Name

Use this field to enter a name for the function. This name will be visible in the Discoverer Administrator in the Edit Calculation window, and in Discoverer Plus if the Available in Discoverer Plus check box has been selected.


Use this field to enter the user ID of the owner of the function. Changing this value enables you to move the reference from a development environment to a production environment.


Use this field to enter the package that contains this function. A package is used in the Oracle database to group many functions together by category for easier management.

Database Link

Use this drop down list to select the database that stores the function. This is a particularly useful feature if you are using distributed databases.

Return Type

Use this drop down list to enter the data type of the data returned by the function. For example, a function might return a character string (char) or a number.


Use this field to enter additional information about the function.


Use this field to change the unique name that Discoverer uses to identify EUL and workbook objects. When matching objects common to different EULs, Discoverer uses identifiers to locate objects in different EULs that refer to the same business object.

Available in Discoverer Plus

Use this check box to enable Discoverer end users to use this function in calculations.


Use this button to test the validity and accuracy of the information you have entered. The Discoverer Administrator generates a test SQL statement that includes the PL/SQL function and tests the query. This test validates the existence of the function (by properly naming and locating it), its owner, and tests the data return type.


Use this button to register a new PL/SQL function. A default function name is generated and fields are initialized with default values. You can then edit the default values to configure the new function as required.


Use this button to remove the PL/SQL function currently selected in the Functions field.


Use this button to display the "Import PL/SQL Functions dialog", where you search for and select the PL/SQL functions (defined in the database) that you want to import. After you import PL/SQL functions, you register them so that Discoverer Administrator can use them. For more information, see "How to register custom PL/SQL functions automatically".