About User Defined Functions

User defined functions enable you to invoke externally available functions from PL/SQL or SQL code within your database.

You can invoke the following external functions using user defined functions:
  • Oracle Cloud Infrastructure Functions: Oracle Cloud Infrastructure Functions are fully managed, multi-tenant, highly scalable, on-demand, Functions-as-a-Service platform. Oracle Cloud Infrastructure Functions are built on enterprise-grade Oracle Cloud Infrastructure and powered by the Fn Project open-source engine. Use Oracle Cloud Infrastructure Functions also referred to as OCI Functions, to focus on developing code to meet the business requirements.

    See Overview of Functions for more information.

  • AWS Lambda: AWS Lambda is a serverless, event-driven compute service that lets you run code for virtually any application or backend service without provisioning or managing servers.

    See AWS Lambda for more information.

  • Azure Function: Azure Function is a serverless compute service that enables users to run event-triggered code without provisioning or managing infrastructure.

    See Azure Functions overview and Create your first function in the Azure portal for more information.

  • External Procedures: External procedures are functions written in a third-generation language (C, for example) and callable from within PL/SQL or SQL as if they were a PL/SQL routine or function.

    See What Is an External Procedure? for more information.

  • Google Cloud Run Function: Google Cloud Run function is a serverless compute service that enables user to run event-triggered code without having to provision or manage infrastructure.

    See Google Cloud Run functions for more information.