// Oracle error reference

ORA-06550: PL/SQL compilation error at line, column

A PL/SQL block failed to compile. The message gives the line and column, and the PLS- error after it says what's wrong.

Error code
ORA-06550
Category
PL/SQL
Error message
line string, column string: string

What it means

ORA-06550 reports a compilation error in an anonymous block or a call, as ORA-06550: line 3, column 5: followed by the actual problem, usually a PLS- error such as PLS-00201: identifier 'X' must be declared or PLS-00103: Encountered the symbol ....

Common causes

  • A syntax error, such as a missing ; or END.
  • Referencing an undeclared variable or an object you can't access (PLS-00201).
  • Calling a procedure with the wrong number or types of arguments (PLS-00306).

How to fix it

  1. Read the PLS- error that follows and go to the line and column given.

  2. For stored code, list the compile errors.

    SELECT line, position, text FROM user_errors
    WHERE name = 'BILLING_PKG' ORDER BY sequence;
  3. If the identifier is another schema's object, qualify it and get the privilege granted directly (not through a role).

Related errors

More pl/sql errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

Work on Oracle in SQLly

A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.