Invoke User Defined Functions

You can invoke external functions such as OCI, AWS Lambda, Google Cloud Run functions and Azure remote functions in your Autonomous AI Database as SQL functions.

• About User Defined Functions

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

• Steps to Invoke OCI Cloud Functions as SQL Functions

  Shows the steps to invoke OCI remote functions as SQL functions in your database.

• Steps to Invoke AWS Lambda as SQL Functions Shows the steps to invoke AWS remote functions as SQL functions in your database.

• Steps to Invoke Azure Functions as SQL Functions

  Shows the steps to invoke Azure remote functions as SQL functions in your database using HTTP trigger.

• Steps to Invoke Google Cloud Run Functions as SQL Functions

  Shows the steps to invoke Google Cloud Run functions as SQL functions in your database.

• Invoke External Procedures as SQL Functions Shows the steps to invoke external procedures using PL/SQL within your database.

• Invoke Generic Scripts on an Autonomous AI Database Instance You can invoke generic scripts, of type BASH, C, or Python on your Autonomous AI Database.

• Invoke Python Scripts with WITH_CONTEXT on Autonomous AI Database

  Shows the steps to invoke Python scripts using WITH_CONTEXT on your database.