How to Trace a Session with Forms Trace in Oracle Forms
Record user actions, triggers, built-ins, and SQL of an Oracle Forms 14.1.2 session with Forms Trace, and read the trace with Xlate.
AI-Assisted
Posts tagged AI-Assisted are created with support from artificial intelligence. I use AI tools to research, draft, and refine ideas—combining human insight with machine precision to deliver clear, informed, and creative content.
How to Manage an Oracle Forms Production Domain
The full Oracle Forms 14.1.2 domain in production: its servers, the start order, maintenance without cutting users off, and the logs.
How to Set the Oracle Forms Runtime Environment with default.env
The environment of the Oracle Forms 14.1.2 runtime process: default.env variables, several environment files, and every other config file.
How to Configure formsweb.cfg in Oracle Forms 14.1.2
How an Oracle Forms 14.1.2 application reaches its users, and how formsweb.cfg sections, URL rules, and parameters control it.
How to Reduce Round Trips to the Forms Server
What each user action sends to the Oracle Forms 14.1.2 server, why a clock is expensive, and how to start faster and serve more users.
How to Reduce Database Round Trips in Oracle Forms
Real measurements from Oracle Forms 14.1.2: what POST-QUERY lookups cost, and how array sizes cut 4,149 database round trips to 19.
How to Run Oracle Reports from a Form Using RUN_REPORT_OBJECT
Report objects, RUN_REPORT_OBJECT, job status, output, and security: running Oracle Reports 14.1.2 from an Oracle Forms 14.1.2 form.
How to Create a Report with Oracle Reports 14.1.2
Oracle Reports 14.1.2 for Forms applications: the domain it needs, the Report Wizard, reports as XML, rwrun, rwservlet, and PDF fonts.
How to Generate REST Packages Using the REST Package Designer in Oracle Forms
Turn an OpenAPI document into PL/SQL with the REST Package Designer of Oracle Forms 14.1.2, then call the generated packages from a form.
How to Call REST Services from Oracle Forms
GET and POST JSON from Oracle Forms 14.1.2 with the new FHTTP and FJSON packages, with status codes, errors, and credentials.
How to Connect a Form to a Web Page Using JavaScript in Oracle Forms
WebSocket JavaScript integration in Oracle Forms 14.1.2: run JavaScript in a web page from a form, and raise form events from the page.
How to Add Java Beans to Oracle Forms
Java beans in bean areas, pluggable Java components, and FBEAN in Oracle Forms 14.1.2, with properties, events, and JAR deployment.
How to Work with Client Files Using WebUtil in Oracle Forms
Reach the user's computer from Oracle Forms 14.1.2 with WebUtil: setup, file dialogs, client images and text files, transfers, and security.
How to Handle Events in Oracle Forms
System and database events in Oracle Forms 14.1.2: client idle, and change notifications that refresh a form when another session changes rows.
How to Use Timers in Oracle Forms
Timers in Oracle Forms 14.1.2: a clock, what repeating timers cost, and the one-shot timer that runs code a trigger cannot.
How to Reuse Objects with Object Libraries in Oracle Forms
Keep every form of an Oracle Forms 14.1.2 application consistent with an object library: subclassing, SmartClasses, and template forms.
How to Base a Block on Transactional Triggers in Oracle Forms
When rows exist in no table: an Oracle Forms 14.1.2 block on transactional triggers that computes a doctor's slots in ON-SELECT and ON-FETCH.
How to Base a Block on a FROM Clause Query in Oracle Forms
Show a report with ANSI joins and analytic functions in an Oracle Forms 14.1.2 block, without creating a view, and see the SQL it sends.