ORA Error Helper for VS Code

Hover any ORA-, PLS- or TNS- error code to see what it means and how to fix it. Works in SQL files, logs, stack traces, Java/Python/C# code and plain text. 251 common Oracle errors are bundled, so it works offline.

Features

• Hover: point at ORA-00942, ora 1403 or PLS-00201 anywhere and get the cause and the fix.
• Explain error (ORA Error Helper: Explain error): uses the selection, or the clipboard if nothing is selected. Also in the editor right-click menu.
• Browse all Oracle errors: searchable list by code or words ("no data", "deadlock", "mutating").
• Find error codes in this file: lists every code in a log file and jumps to it.
• Each explanation links to its page in the online ORA error reference.

More tools

• PL/SQL Lint for VS Code: catches PL/SQL bugs while you type (free).
• JetBrains IDEs: ORA Error Helper, PL/SQL Lint, Oracle Plan Reader.
• Book: PL/SQL in Practice (Kindle).

The explanations are written for this extension and are not Oracle documentation. Oracle is a registered trademark of Oracle Corporation; this extension is not affiliated with Oracle.

MIT license.