ORA-06550: line/column PLS-... PL/SQL compilation error
OracleWhat does it mean?
A syntax or semantic error was found while compiling a PL/SQL block, procedure or anonymous block. The code failed at the compilation stage before it could run.
Why does it happen?
Typos, a reference to an undeclared variable or object, a call with the wrong number/type of parameters, a missing semicolon, a call to a nonexistent procedure/package, or a missing privilege.
How to fix it
Go to the line and column number in the error message; read the PLS-XXXX sub-code. To see all compilation errors: SHOW ERRORS; or SELECT * FROM user_errors WHERE name = 'OBJECT_NAME'; Verify object names, parameter signatures and the required GRANTs, then recompile.
More from this engine
- ORA-02292integrity constraint violated - child record found
- ORA-00979not a GROUP BY expression
- ORA-00918column ambiguously defined
- ORA-04068existing state of packages has been discarded
- ORA-01427single-row subquery returns more than one row
- ORA-12899value too large for column
- ORA-30926unable to get a stable set of rows in the source tables