Import PL/SQL Functions dialog

Use this dialog to select the PL/SQL function that you want to import into the End User Layer.

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"

The functions listed in this dialog have been defined in the database using SQL commands. For more information about defining PL/SQL functions in the database, see the PL/SQL User's Guide and Reference.

Note: To register a PL/SQL function you must have EXECUTE privilege on the function.

Show PL/SQL functions where Owner matches

Use this field to enter search criteria to filter the PL/SQL functions that you want to display in the Select functions to import field.

Note: This field might improve performance when there are very large numbers of PL/SQL functions to display.

Go

Use this button to search for functions that match the search criteria that you entered in the Show PL/SQL functions where Owner matches field, and list the results in the Select functions to import field.

Select functions to import

Use this list to select one or more functions that you want to import from the database.

You can select more than one function by pressing the Ctrl key and clicking another function.

OK

Use this button to import the functions selected and display to the "PL/SQL Functions dialog: Functions tab".