No32K - HTML to PL/SQL Compiler

A VS Code extension that compiles HTML templates with PL/SQL injections into PL/SQL procedures using htp.p/prn calls, with PL/SQL-aware linting support.

Features

Clean HTML Authoring: Write readable HTML with optional inline PL/SQL injections
Smart Compilation: Automatically chunks large content and handles q-quote delimiter selection
PL/SQL-Aware Linting: Lint HTML, CSS, and JavaScript while ignoring PL/SQL injections and manual break lines
Configurable: Extensive configuration options for different use cases

Quick Start

Install the extension
Open an HTML file
Add PL/SQL injections using {{= expression }} or {{ statements }}
Run No32K: Compile HTML → PL/SQL (htp.p) to generate PL/SQL code
Run No32K: Lint (PL/SQL-aware) to validate HTML structure

Injection Syntax

Expression Injection

<h1>Welcome {{= user_name }}</h1>
<p>Current time: {{= TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') }}</p>

Generates:

htp.prn(q'[<h1>Welcome ]');
htp.prn(to_char(user_name));
htp.prn(q'[</h1>]');

Statement Injection

{{ IF user_role = 'ADMIN' THEN }}
  <div class="admin-panel">Admin Controls</div>
{{ END IF; }}

Generates:

IF user_role = 'ADMIN' THEN
    htp.prn(q'[<div class="admin-panel">Admin Controls</div>]');
END IF;

Manual Break Compatibility

Legacy manual break lines are ignored by the linter:

<div>
q'~<p>Some content~' || some_function() || q'~more content</p>~'
</div>

Commands

No32K: Compile HTML → PL/SQL (htp.p): Generate PL/SQL procedure from HTML template
No32K: Lint (PL/SQL-aware): Run HTML linting with PL/SQL injection awareness

Configuration

Basic Settings

{
  "no32k.target.objectName": "${fileBasenameNoExtension}_page",
  "no32k.chunkSize": 15000,
  "no32k.usePrn": true,
  "no32k.addMimeHeader": true,
  "no32k.minifyHtml": true,
  "no32k.wrapToChar": true
}

Linting Settings

{
  "no32k.lint.onSave": true,
  "no32k.lint.ignoreManualBreakRegex": "q'~[\\s\\S]*?~'\\s*\\|\\|[\\s\\S]*?\\|\\|\\s*q'~",
  "no32k.lint.enableJs": true,
  "no32k.lint.enableCss": true
}

Generated PL/SQL Structure

/*
 * Generated by No32K - HTML to PL/SQL Compiler
 * Procedure: example_page
 * Generated: 2025-09-30T12:00:00.000Z
 */

CREATE OR REPLACE PROCEDURE example_page
AS
BEGIN
    -- Set HTTP content type header
    owa_util.mime_header('text/html', FALSE);
    owa_util.http_header_close;

    htp.prn(q'[<!DOCTYPE html>
<html>
<head>
    <title>Example Page</title>
</head>
<body>
    <h1>Welcome ]');
    
    -- Expression from line 8: {{= user_name }}
    htp.prn(to_char(user_name));
    
    htp.prn(q'[</h1>
</body>
</html>]');

EXCEPTION
    WHEN OTHERS THEN
        htp.prn('<p>Error generating page: ' || SQLERRM || '</p>');
        RAISE;
END example_page;
/

Key Features

Smart Chunking

Automatically splits large text content into chunks under 15KB (configurable)
Prefers splitting at newline boundaries for readability
Handles very large HTML files safely

Dynamic Q-Quote Selection

Automatically selects q-quote delimiters that don't conflict with content
Tries bracket pairs first, then single characters, then rare Unicode characters
Falls back to string concatenation if no safe delimiter found

PL/SQL-Aware Linting

Removes {{...}} injections before HTML linting
Ignores manual break lines matching configurable regex pattern
Maps diagnostic line numbers back to original source
Supports HTMLHint rules optimized for templates

Oracle Integration

Direct compilation to Oracle database
Detailed error reporting with line numbers
Connection testing and validation
Support for various Oracle connection methods

Requirements

VS Code 1.74.0 or higher
Node.js dependencies (automatically installed):
- html-minifier-terser for HTML minification
- html-validate for modern HTML validation
- eslint for JavaScript linting
- stylelint for CSS linting

Examples

See the examples/ directory for sample HTML templates demonstrating various features:

basic-template.html - Simple template with expressions
complex-template.html - Advanced template with statements and conditions
legacy-template.html - Template with manual break compatibility

Troubleshooting

Common Issues

"Linting shows false positives"
- Adjust ignoreManualBreakRegex pattern in settings
- Check that PL/SQL injections use correct {{...}} syntax
- Use .no32k.html files for better syntax highlighting
"Generated PL/SQL has compilation errors"
- Check that expressions return VARCHAR2/CHAR types or enable wrapToChar
- Verify that statement injections contain valid PL/SQL syntax
"Red squiggly lines in wrong positions"
- Ensure you're using .no32k.html files
- Check the No32K Diagnostics output for position mapping details

Debug Mode

Enable debug logging by setting:

{
  "no32k.debug": true
}

Contributing

Fork the repository
Create a feature branch
Make your changes
Add tests for new functionality
Submit a pull request

License

MIT License - see LICENSE file for details.

Changelog

0.1.0

Initial release
Basic HTML to PL/SQL compilation
PL/SQL-aware HTML linting
Oracle database integration
Configurable chunking and quoting

No32K

0xCarbon