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
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
;orEND. - 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
-
Read the PLS- error that follows and go to the line and column given.
-
For stored code, list the compile errors.
SELECT line, position, text FROM user_errors WHERE name = 'BILLING_PKG' ORDER BY sequence;
-
If the identifier is another schema's object, qualify it and get the privilege granted directly (not through a role).
Related errors
ORA-06512at line (PL/SQL error stack)ORA-06508PL/SQL: could not find program unit being calledORA-00904invalid identifier
More pl/sql errors
ORA-01403no data foundORA-01422exact fetch returns more than requested rowsORA-06502PL/SQL: numeric or value errorORA-06503PL/SQL: function returned without valueORA-04091table is mutating, trigger may not see itORA-04088error during execution of triggerORA-04068existing state of packages has been discarded
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
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.