Skip to main content

Posts

Showing posts from September, 2026

Zero-Plugin Barcode & QR Scanner in Oracle APEX

I built a barcode scanner for Oracle APEX without installing a single plugin No native extensions, no paid plugin, just the browser's camera and a bit of JavaScript. Here's the whole thing, step by step. ▶ Live Demo I built this for a check-in system where scanning tickets manually was too slow. No plugin, no paid SDK just the browser's camera, a bit of JavaScript, and PL/SQL on the APEX side. What you'll end up with: tap "Start Scanner", point the phone at a QR code, and the person's name shows up on screen as checked in instantly, straight from the database. 1 Set up the page and the camera window Blank APEX page (mine is page 17). Add a static content region with a video tag that's where the camera feed shows up. HTML Static Content Region Copy ...

APEX IG Trick: Trap the Cursor on Invalid Cells Using gotoCell()

// oracle apex · interactive grid A small fix that saved a data entry team hours every day Why the normal way of validating an Interactive Grid column looks fine on your screen, but slows real users down a lot. A note from a real APEX project · Lose Focus validation, Dynamic Actions, and one small timing fix This started as a small bug fix. It ended up saving a whole team a lot of time every day. I was working on an Oracle APEX app where users enter a large number of records every day using an Interactive Grid. One column, SAL , should never be left empty. So I did what most of us do: I added the normal Lose Focus validation to stop users from tabbing past it while it's blank. I tested it myself, saw the red error message, and moved on. It looked done. Then I sat with someone who actually uses this grid all day, and I saw the real problem. The normal way of doing this If you've built an Interactive Grid before, this will look familia...