- 10 Nov, 2021
- 0 Comments
- 1 Min Read
ORA-06550: line string, column string: string
ORA-06550: line string, column string: string
Cause: Usually a PL/SQL compilation error.
Action: none
ORA-06550 is a very simple exception, and occurs when we try to execute a invalid pl/sql block like stored procedure. ORA-06550 is basically a PL/SQL compilation error. Lets check the following example to generate ORA-06550:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | SQL> create or replace procedure myproc 2 as 3 begin 4 for c in (select * from scott.emp) 5 loop 6 dbms_output.put_line(c.empno || ' ' || c.ename || ' ' || sal); 7 end loop; 8 end; 9 /Warning: Procedure created with compilation errors.SQL> exec myprocBEGIN myproc; END; *ERROR at line 1:ORA-06550: line 1, column 7:PLS-00905: object MYUSER.MYPROC is invalidORA-06550: line 1, column 7:PL/SQL: Statement ignored |
Here we create a stored procedure "myproc" which has some compilation errors and when we tried to execute it, ORA-06550 was thrown by the Oracle database. To debug ORA-06550 we can use "show error" statement as:
1 2 3 4 5 6 7 | SQL> show error procedure myprocErrors for PROCEDURE MYPROC:LINE/COL ERROR-------- -----------------------------------------------------------------6/3 PL/SQL: Statement ignored6/60 PLS-00201: identifier 'SAL' must be declared |
Now we know variable SAL is not defined and must be written as c.sal. So we will need to make corrections in "myproc" as
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | SQL> create or replace procedure myproc 2 as 3 begin 4 for c in (select * from scott.emp) 5 loop 6 dbms_output.put_line(c.empno || ' ' || c.ename || ' ' || c.sal); 7 end loop; 8 end; 9 /Procedure created.SQL> set serveroutput onSQL> exec myproc7369 SMITH 8007499 ALLEN 16007521 WARD 12507566 JONES 29757654 MARTIN 12507698 BLAKE 28507782 CLARK 24507788 SCOTT 30007839 KING 50007844 TURNER 15007876 ADAMS 11007900 JAMES 9507902 FORD 30007934 MILLER 1300PL/SQL procedure successfully completed. |