Oracle Cloud Infrastructure Documentation
Try Free Tier

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. From the list of function libraries on the User-defined functions page, select the name of the library.

    If you need help finding the User-defined functions page, see Listing Function Libraries.

  2. In the Functions section of 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.

Was this article helpful?