Skip to content
APEX from the Field
  • Home
  • About Me
  • Certifications
  • ACE Profile
  • DevDF
APEX from the Field
  • An observed event is examined while the expected integration response remains an empty outline.
    APEX

    The Missing Log Proves Nothing

    ByDênio Flávio 09/27/202609/27/2026

    Order 42 failed at checkout. The total was BRL 129, and no integration response was recorded. Support’s proposed explanation was simple: the integration had never been called. That explanation turned out to fit this attempt. The empty response log was not what established it. The Incident Is the Prompt followed an exception to an input…

    Read More The Missing Log Proves NothingContinue

  • One purchase intention branching into two order receipts
    APEX | PL/SQL

    One Click, Two Orders

    ByDênio Flávio 09/20/202609/20/2026

    The buyer clicked Place order once. The application returned two purchase references: Order #21 and Order #22, each for BRL 2,098. Both were confirmed. Neither looked like a failed transaction. In The Incident Is the Prompt, an exception gave the investigation a starting point. Here, success was the symptom. Before looking for a faulty line,…

    Read More One Click, Two OrdersContinue

  • A user report connects to evidence and a focused source location
    APEX | PL/SQL

    The Incident Is the Prompt

    ByDênio Flávio 09/12/202609/12/2026

    For this series, I want to explore AI beyond writing code: using those same tools to understand what happened when an application does not behave as expected. The work between a screenshot and a diagnosis involves finding the execution, connecting its records, and deciding where to inspect the code. An early assumption can send that…

    Read More The Incident Is the PromptContinue

  • Security After the Prompt cover showing AI-generated intent flowing through APEXLang and the APEX runtime into governed execution controls
    APEX

    Security After the Prompt: Why the APEX Runtime Changes AI-Generated Applications

    ByDênio Flávio 08/23/202608/23/2026

    I have spent enough time reviewing enterprise applications to know that the first successful run is rarely the difficult part. The difficult part begins later, when someone has to explain why a user can see a page, where a secret is stored, which code changes data, how a session value arrived there, and what must…

    Read More Security After the Prompt: Why the APEX Runtime Changes AI-Generated ApplicationsContinue

  • Plain SQL status values passing through Oracle APEX Template Directives and becoming readable status badges
    APEX

    The Status Badge Did Not Belong in My SQL Query

    ByDênio Flávio 08/17/202608/23/2026

    There was a point when one of my report queries stopped returning only business data. It also decided which CSS class represented an error, assembled pieces of HTML, omitted empty messages, and formatted small lists of labels. The report still worked, but the SQL had quietly become part query and part user interface. I love…

    Read More The Status Badge Did Not Belong in My SQL QueryContinue

  • Customer language entering an Oracle APEX vector search boundary and returning ranked service candidates
    APEX

    A Service Advisor Should Not Have to Send a 384-Number Vector

    ByDênio Flávio 08/10/202608/23/2026

    An Oracle APEX service-candidate search that keeps the 384-number embedding behind the application boundary.

    Read More A Service Advisor Should Not Have to Send a 384-Number VectorContinue

  • Customer complaint flowing through an ORDS AutoREST vector search and returning ranked service recommendations
    ORDS

    From customer complaint to service recommendation: automatic vector search with ORDS AutoREST

    ByDênio Flávio 08/02/202608/23/2026

    In March 2025, I earned the Oracle AI Vector Search Certified Professional certification. I studied vector fundamentals, embeddings, similarity search, and vector indexes. The concepts made sense, but I kept looking for small, practical places to use them. ORDS gave me another one. With the automatic vectorSearch endpoint in AutoREST, I could take those concepts out of the study…

    Read More From customer complaint to service recommendation: automatic vector search with ORDS AutoRESTContinue

  • Purchase request passing through policy checks and explanation before human confirmation
    APEX

    When a Purchase Request Needs More Than a Chat Window

    ByDênio Flávio 07/12/202608/23/2026

    I had been waiting for my Oracle APEX environment on OCI to be updated to version 26. This week it finally happened. So, to celebrate properly, I decided to build a small field-style demo around one of the features that immediately caught my attention in this release: native AI Agents in Oracle APEX. The interesting…

    Read More When a Purchase Request Needs More Than a Chat WindowContinue

  • Custom Oracle APEX operations home page composed from metrics, queues, signals, and actions
    APEX | PL/SQL

    When APEX Needs a Custom Home Page

    ByDênio Flávio 07/05/202608/23/2026

    Most of the time, when I build an APEX page, I try to stay inside the declarative model for as long as the page still feels honest. Native regions, template components, lists, cards, reports, buttons, dynamic actions, and Universal Theme options are usually easier to maintain because they remain visible in the Builder and other…

    Read More When APEX Needs a Custom Home PageContinue

  • Completed AI answer entering a human feedback and triage loop
    APEX

    I Needed Feedback for an APEX AI Agent. The Feature Was Already There

    ByDênio Flávio 06/21/202608/23/2026

    User feedback has a bad reputation among developers. It arrives without reproduction steps. It calls an unclear label a bug and a business-rule disagreement a system failure. Sometimes it appears in a meeting three weeks after the user quietly found another way to finish the work. It is tempting to treat feedback as a necessary…

    Read More I Needed Feedback for an APEX AI Agent. The Feature Was Already ThereContinue

Page navigation

1 2 3 Next PageNext

Search

Categories

  • APEX (17)
  • ORDS (4)
  • PL/SQL (10)
  • SQL (3)

RECENT posts

  • The Missing Log Proves Nothing09/27/2026
  • One Click, Two Orders09/20/2026
  • The Incident Is the Prompt09/12/2026
  • Security After the Prompt: Why the APEX Runtime Changes AI-Generated Applications08/23/2026
  • The Status Badge Did Not Belong in My SQL Query08/17/2026

Tags

Agents Ajax Callback annotations API authentication scheme Collections debug Dynamic Action dynamic content feedback IA jQuery n2sql oauth ords pl/sql plsql Process Social Sign-In sql Template Directives type UI url Vector Search xml

  • Home
  • About Me
  • Certifications
  • ACE Profile
  • DevDF
Linkedin Github YouTube

© 2026 APEX from the Field

Scroll to top
  • Home
  • About Me
  • Certifications
  • ACE Profile
  • DevDF