ORA Error ReferenceSearch errors

All errors › PLS errors

PLS-00103: Encountered the symbol X when expecting one of the following

What it means

Syntax error: a missing semicolon, END, THEN, LOOP, or a keyword in the wrong place.

How to fix it

Look at the line before the reported position: a missing ";" at the end of the previous statement is the most common cause.

Catch it before it runs

ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip.
PL/SQL Lint
Flags risky PL/SQL patterns while you type.
Oracle Plan Reader
Reads execution plans and points at the slow step.
PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.

Nearby errors

Updated 2026-11-12.