Oracle9i Discoverer Administrator Administration Guide Version 9.0.2 Part Number A90881-02 |
|
Use this dialog to define arguments for PL/SQL functions that are registered.
You can register PL/SQL functions that have been defined in the database, using SQL commands.
For more information, see:
"Why do you need PL/SQL functions?"
Use this tab to display the "PL/SQL Functions dialog: Functions tab".
This list displays a Oracle-supplied PL/SQL functions and user-defined PL/SQL functions that have already been registered for use with Discoverer Administrator.
This displays a list of arguments defined for the function currently selected in the Functions list.
Use this button to create a new argument. A default argument name is generated and fields are initialized with default values. You can then edit the default values to configure the new argument as required.
Use this button to delete the currently selected argument. The argument is removed from the Arguments list.
Use these buttons to rearrange the arguments in the Arguments list. This is useful if an argument is out of place ordinally, or if the function itself has been modified and you need to update the function definition.
Use this field to enter the argument name. When you add an argument, a default name is created by Discoverer Administrator.
Use this field to enter additional information about the argument. When you add an argument, a default description is created by Discoverer Administrator.
Use this field to specify the argument data type (the default is Number).
Use this field to change the unique name that Discoverer uses to identify EUL and workbook objects. Also known as a conceptually identical object.
Use this radio button when the argument is an optional argument to the function.
Use this radio button when the argument is a mandatory argument to the function.
|
Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|