Blog Archive

  • Server-Side Geocoding & AI-Driven Point of Interest Lookup #joelkallmanday

    In APEX on Autonomous Database, use declarative, server-side geocoding to find coordinates for an address. Then you can see it on a map, measure its distance from another point, find it within a radius, and process it with other spatial data features. Use an AI Configuration to create a smart web service with natural language. It … Continue reading “Server-Side Geocoding & AI-Driven Point of Interest Lookup #joelkallmanday”

  • Sanitizing HTML Server-Side

    A colleague asked how he might sanitize client-submitted HTML to remove potential Cross-Site Scripting vulnerabilities. His use case was an ORDS REST service accepting HTML content, so he wanted to sanitize it using PL/SQL. After consulting the functions in the APEX_ESCAPE package, I convinced myself we needed a different strategy. The functionality could also come … Continue reading “Sanitizing HTML Server-Side”

  • Including User Input in AI Prompt

    Sometimes it can be useful to include end-user input in a generative AI system prompt. You can do this with both the Generate Text with AI dynamic action, as well as the Show AI Assistant one. We’ll explore two simple APEX 24.2 sample apps that illustrates the respective techniques. Generating Text with AI from User … Continue reading “Including User Input in AI Prompt”

  • Edit Collection with Interactive Grid

    An Oracle colleague asked how to create an editable Interactive Grid against an APEX collection. I share the solution here along with a few observations I learned while creating it. Client Side Grid Model An interactive grid manages an in-memory record set in the browser. This is called the model. An editable grid’s model also … Continue reading “Edit Collection with Interactive Grid”

  • Collecting Data in Human Tasks Orchestrated by a Workflow

    When an APEX workflow assigns a human task to one or more potential owners, it shows up in their “Universal Task List” page of “todo” items. Sometimes an action task or an approval task requires the task owner to input additional data to inform the business process the workflow is orchestrating. The task detail page … Continue reading “Collecting Data in Human Tasks Orchestrated by a Workflow”