A comprehensive VS Code / Cursor extension for modernizing Oracle Forms development. Edit FMB files visually, manage PL/SQL code, compile FMX binaries, connect to Oracle databases, and integrate with version control — all from your IDE.
Key Features
- Canvas Editor — Drag-and-drop visual editor for Oracle Forms canvases in a WebView panel. Zoom, pan, resize, and reposition form items.
- Tree View — Full FMB structure browser showing all object types: Blocks, Items, Triggers, Program Units, Canvases, Windows, Alerts, LOVs, Record Groups, Parameters, Visual Attributes, Property Classes, and more.
- Property Panel — Click any node to inspect and edit properties in a styled WebView panel with grouped fields.
PL/SQL Development
- Code Editing — Click any trigger or program unit to edit PL/SQL with syntax highlighting.
- Validation — Static analysis for unbalanced BEGIN/END, missing semicolons, unclosed strings, and mismatched parentheses.
- SQL Export — Extract all PL/SQL code from a module into a single SQL file.
FMB Conversion & Compilation
- FMB ↔ JSON — Convert binary FMB files to editable JSON and back. Cloud or local conversion.
- FMX Compilation — Compile FMB to FMX using local Oracle Forms, a companion server, or the cloud compile service.
- Stub Database — Auto-generate Oracle database stubs from FMB references for compilation without a real database. Supports Oracle 8i through 21c.
- Templates — Create new modules from pre-built templates (Blank, Single-Record, Master-Detail, Query-Only).
Oracle Database Integration
- DB Browser — Add Oracle DB connections and browse schemas, tables, views, and stored procedures.
- Connection Testing — Test connectivity before saving connections.
- Zero-Knowledge Security — Credentials are stored in VS Code's SecretStorage (OS keychain), never in plain text.
Version Control Integration
- Git / SVN / TFS / GitHub — Full VCS support via the companion server.
- FMB Diff — Compare FMB files between commits by converting them to JSON and using VS Code's diff editor.
- Status, Commit, Branch, History — All VCS operations available from the command palette.
Diff & Comparison
- Module Diff — Compare original vs modified module structure using VS Code's built-in diff editor.
- PL/SQL Diff — Diff only the PL/SQL code portions of two modules.
Internationalization
- 5 languages: English, Turkish, German, Spanish, Portuguese.
Quick Start
- Install the extension from the VS Code Marketplace or a
.vsix file.
- Click the G-FMB Studio bird icon in the activity bar.
- Click Open FMB / JSON File or use
Ctrl+Shift+P → G-FMB: Open FMB / JSON File.
- Browse the tree, edit PL/SQL, use the canvas editor, and export your changes.
No local Oracle installation required. The extension uses cloud services by default.
Extension Settings
| Setting |
Default |
Description |
gFmbConverter.apiUrl |
https://g-fmb.com/api |
G-FMB web API endpoint |
gFmbConverter.language |
en |
Interface language: tr, en, de, es, pt |
gFmbConverter.fmbToolPath |
(empty) |
Path to local FmbTool.exe for offline conversion |
gFmbConverter.oracleFormsPath |
(empty) |
Oracle Forms installation directory |
gFmbConverter.cloudApiSecret |
(empty) |
API secret for cloud FmbTool service |
gFmbConverter.companionUrl |
(empty) |
Remote companion server URL (leave empty for localhost) |
gFmbConverter.companionApiKey |
(empty) |
API key for remote companion server |
gFmbConverter.compileTarget |
11g |
Oracle DB version for stub compilation (8i–21c) |
Commands
| Command |
Description |
G-FMB: Open FMB / JSON File |
Open and parse an FMB or JSON file |
G-FMB: Export (FMB / JSON / SQL) |
Export module in your chosen format |
G-FMB: New FMB from Template |
Create a new module from a template |
G-FMB: Add New Object |
Add blocks, items, triggers, etc. |
G-FMB: Show Diff |
Compare original vs modified module |
G-FMB: Validate PL/SQL |
Run static PL/SQL analysis |
G-FMB: Visual Canvas Editor |
Open the visual form editor |
G-FMB: Compile FMX |
Compile FMB to FMX (local) |
G-FMB: Cloud Compile FMB to FMX |
Compile via cloud service |
G-FMB: Companion Compile FMB to FMX |
Compile via companion server |
G-FMB: Add Oracle DB Connection |
Add a new Oracle DB connection |
G-FMB: Browse Oracle DB Schemas |
Browse connected database schemas |
G-FMB: VCS Status |
Show Git/SVN/TFS status |
G-FMB: Commit Changes |
Commit via VCS |
G-FMB: VCS File History |
View file history |
G-FMB: Switch Branch |
Switch VCS branch |
G-FMB: Diff FMB Against HEAD |
Compare FMB with HEAD revision |
G-FMB: Login |
Sign in with G-FMB account |
G-FMB: Logout |
Sign out |
G-FMB: Check License |
View plan and usage |
G-FMB: Set Language |
Change UI language |
Architecture
Your Machine Companion Server Cloud Services
┌──────────────┐ ┌──────────────────┐ ┌─────────────────┐
│ VS Code │◄───────►│ fmb serve │ │ g-fmb.com API │
│ Extension │ HTTP │ (localhost:6832) │ │ FmbTool API │
│ │ │ ┌──────────────┐ │ └────────┬────────┘
│ ┌────────┐ │ │ │ Oracle Forms │ │ │
│ │Canvas │ │ │ │ FMX Compile │ │ │
│ │Editor │ │ │ ├──────────────┤ │ Cloud FMB↔JSON
│ ├────────┤ │ │ │ Oracle DB │ │ Cloud FMX Compile
│ │Tree │ │ │ │ Connections │ │ │
│ │View │ │ │ ├──────────────┤ │ │
│ ├────────┤ │ │ │ Git/SVN/TFS │ │ │
│ │Property│ │ │ │ VCS Ops │ │ │
│ │Panel │ │ │ └──────────────┘ │ │
│ └────────┘ │ └──────────────────┘ │
└──────────────┘ │
│ │
└──────────────── Cloud API ──────────────────────────┘
Local Companion Server
Install and run the companion server for full local capabilities:
npm install -g g-fmb-cli
fmb serve
The companion server enables FMX compilation, Oracle DB browsing, local file access, and VCS operations from the extension.
Requirements
- VS Code 1.85+ or Cursor (latest)
- Internet connection for cloud features, OR local companion server for offline use
- Optional: Oracle Forms 6i/12c for local FMX compilation
- Optional:
oracledb Node.js driver for Oracle DB browsing
Links
License
Proprietary — see G-FMB Studio for details. A product of DMG Software.
| |
