Home >
Oracle/PLSQL >
Oracle Error Messages
Oracle/PLSQL: ORA-06550
Learn the cause and how to resolve the ORA-06550 error message in Oracle.
Description
When you encounter an ORA-06550 error, the following error message will appear:
ORA-06550: line num, column num: str
Cause of Error
You tried to execute an invalid block of PLSQL code (like a stored procedure or function), but a compilation error occurred.
How to Resolve the Error
The option(s) to resolve this Oracle error are:
Option #1
Refer to the line and column numbers (in the error message) to find the compilation error and correct it. Then try recompiling your code.
Let's look at an example of how to resolve an ORA-06550 error. For example, if you created a procedure calledTestProc as follows:
SQL> CREATE OR REPLACE PROCEDURE TestProc
2 AS