12.5 Python API for Embedded Python Execution

You can invoke user-defined Python functions directly in an Oracle database instance by using Embedded Python Execution functions.

Python API for Embedded Python Execution is described in the following topics.

Topics:

• About Python API for Embedded Python Execution
  
• Run a User-Defined Python Function
  Use the oml.do_eval function to run a user-defined input function that explicitly retrieves data or for which external data is not required.
• Run a User-Defined Python Function on the Specified Data
  Use the oml.table_apply function to run a Python function on data that you specify with the data parameter.
• Run a Python Function on Data Grouped By Column Values
  Use the oml.group_apply function to group the values in a database table by one or more columns and then run a user-defined Python function on each group.
• Run a User-Defined Python Function on Sets of Rows
  Use the oml.row_apply function to chunk data into sets of rows and then run a user-defined Python function on each chunk.
• Run a User-Defined Python Function Multiple Times
  Use the oml.index_apply function to run a Python function multiple times in Python engines spawned by the database environment.
• Save and Manage User-Defined Python Functions in the Script Repository
  The OML4Py script repository stores user-defined Python functions for use with Embedded Python Execution functions.