EgisedgeOracle Partner
SetupEgisedge PlaybooksAPEX

Playbook: Set up APEX with OCI Generative AI

Steps to connect an Oracle APEX app to OCI Generative AI for chat, summarisation or RAG.

Ask an Egisedge consultant
  1. Provision Autonomous Database (or APEX service) and create the APEX workspace.
  2. In OCI, enable Generative AI in a supported region and create an IAM policy for the database or user.
  3. Create an API key or resource principal and store it as APEX Web Credentials.
  4. In APEX Workspace Utilities, configure a Generative AI service pointing to OCI Generative AI.
  5. Add AI features: AI Assistant region, or call the model with APEX_AI / APEX_WEB_SERVICE from PL/SQL.
  6. For RAG, store embeddings in a VECTOR column and retrieve with VECTOR_DISTANCE before calling the model.
  7. Log prompts and responses for audit; add rate limits.

Reference: APEX documentation, OCI Generative AI documentation, AI Vector Search.