Skip to main content

Posts

Showing posts from July, 2026

No SQL. No Filters. Just Ask: AI Powered Natural Language Reports in Oracle APEX

Oracle APEX Build Log No SQL. No Filters. Just Ask: AI Powered Natural Language Reports in Oracle APEX A small experiment that turned into a full working feature on my APEX app I have been building APEX apps for a while now, and one thing that always bugged me is how much effort normal users have to put in just to find one record. They open the app, they see 200 rows, and then they get stuck trying to figure out which filter icon does what. Most of my end users are not technical people. They do not know what an Interactive Report filter is, and honestly they should not need to know. So I asked myself, what if a person could just type what they want in plain English and the report configures itself. No SQL. No filters. Just ask. That line actually became the title of this whole thing because it is literally what I wanted to build. Quick context: This is built on top of a normal Interactive Report showing customer data, Customer Id, Full Name and Email Address. On to...

From Chatbot to Co-Worker: Building a Production Ready AI Agent in Oracle APEX

Oracle APEX 26.1 From Chatbot to Co-Worker: Building a Production Ready AI Agent in Oracle APEX Most AI Agent demos stop the moment the chat box says something clever. I wanted to know what happens after that, when a real support team asks who can call this thing, what happens if it gets something wrong, and can it run without me sitting there watching a chat window. Jefith Shalin Oracle APEX 26.1 One sitting, one working app Live Demo GitHub Repo TICKET-01 STATUS: OPEN Why I built a support desk instead of a toy demo Every AI Agent tutorial I read followed the same pattern. Open the builder, add a tool, type a question in a chat box, watch it call the tool, done. That is a fine five minute video. It is not something you can show your team lead and say "this is ready for staff to use." So I picked something boring on purpose, a support ticket desk, because boring is where the ...

Building a Screen and Webcam Recorder Inside Oracle APEX

Oracle APEX JavaScript MediaRecorder API Debugging Log Building a Screen and Webcam Recorder Inside Oracle APEX A real walkthrough of what worked, what broke, and how I fixed it, step by step. Part of a series 1 Screen Recorder in Oracle APEX (Single Stream) 2 Screen Recorder in Oracle APEX (Multi Stream) 3 Screen + Webcam Recorder (You are here) I have written separately about a screen recorder in APEX in Part 1 and a multi stream webcam recorder in APEX in Part 2 . A few readers asked me the same question after that. Can both run together, at the same time, in one recording. So I sat down to actually build it, and this post is basically my notes from that whole process, including the parts that did not work on the first try. If you just came here to grab the working code, it is all below with copy buttons on every block. But I am also going to walk through the mistakes because I think that is the part that ...