Oracle Cloud Infrastructure Documentation

Adding Function Parameters

Before you can use input parameters in a user-defined function, create them in the same panel as you create the function or edit the existing function.

  1. On the User-defined functions page, Function libraries list, select the name of the library that you want to work with. If you need help finding the page or the list of libraries, see Listing Function Libraries.
  2. In the Functions section on the library details page, select Create function or select the name of the function that you want to edit.
  3. In the Expression builder section of the panel that appears, select Input parameters.

    If a parameter that you want to use is already added, it's listed under Input parameters.

  4. From the Actions menu, select Add input parameters.
  5. In the Add input parameters panel, enter a name and description for the parameter that you want to add, and select a data type for it.
  6. To add another parameter, select Additional parameter and enter the parameter information. Repeat the procedure to add more parameters.
  7. When you have finished adding the parameters that you want to use in the function, select Add.

    The parameters are listed under Input parameters in the Expression builder section.

  8. In the create or edit function panel, select Create or Save changes.