Presentation by: Jonathan Dixon
Typical AI-powered applications rely on unstructured responses; however, many use cases require structured outputs and controlled execution of business logic. AI function calling bridges this gap by enabling large language models (LLMs) to propose function calls that your application executes, returning results securely and predictably.
In this session, we’ll explore how to implement AI function calling within Oracle APEX using the OpenAI Responses API. You’ll learn:
1. How function calling differs from RAG (Retrieval Augmented Generation) and why it can be more efficient
2. How to design and expose PL/SQL functions for AI-driven workflows
3. An end-to-end integration example, including JSON payloads, function validation, and secure execution patterns
4. We’ll also cover security considerations, error handling, and example use cases.
By the end of the session, you’ll know how to safely embed AI into APEX apps while maintaining complete control over your business logic and data.
Comments are closed