DBMS_CLOUD_FUNCTION Package, with support for External Procedures

With Oracle Autonomous AI Database on Dedicated Exadata Infrastructure deployments, you can use the subprograms in DBMS_CLOUD_FUNCTION package to develop applications with SQL and PL/SQL User Defined Functions that invoke remote functions deployed in the OCI and AWS cloud, and external procedures implemented in a custom OCI compute VM. Cloud Functions are serverless compute engines in the OCI and AWS cloud. External procedures are routines written in a third-generation language and invoked as SQL functions or PL/SQL procedures or functions. SQL and PL/SQL are best suited for fast and efficient data and transaction processing in the database. Cloud functions and External procedures can complement SQL and PL/SQL in-database processing by executing compute and memory-intensive tasks in a remote VM and providing the results back to the database. Typical examples of such tasks are scientific and engineering problems whose computational libraries exist in the cloud, or in the Linux OS (and are not easily portable to the database), offline data analysis, control of real-time devices and processes, and so on.

See Invoke Cloud Functions and External Procedures , and DBMS_CLOUD_FUNCTION Package for details.