SOLVED

ORA-06550: line string, column string: string

Asked by OracleDba••12 views•oracle

#oracle#error

Solutions(1)

Accepted Solution
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
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:

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 myproc

BEGIN myproc; END;

      *

ERROR at line 1:

ORA-06550: line 1, column 7:

PLS-00905: object MYUSER.MYPROC is invalid

ORA-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:

SQL> show error procedure myproc

Errors for PROCEDURE MYPROC:

LINE/COL ERROR

-------- -----------------------------------------------------------------

6/3      PL/SQL: Statement ignored

6/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

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 on

SQL> exec myproc

7369 SMITH 800

7499 ALLEN 1600

7521 WARD 1250

7566 JONES 2975

7654 MARTIN 1250

7698 BLAKE 2850

7782 CLARK 2450

7788 SCOTT 3000

7839 KING 5000

7844 TURNER 1500

7876 ADAMS 1100

7900 JAMES 950

7902 FORD 3000

7934 MILLER 1300

PL/SQL procedure successfully completed.
OracleDba•

Post Your Solution