Component must be declared error (ORA-06550)

Question

Im getting this error:

ORA-06550:line 1, column 25:PLS-00302: component PA_EXCEPTION_LIST_UPDATE must be declared: line1, column 7:PL/SQL: Statement ignored.

I can't figure out what i did wrong.

   PROCEDURE Pa_exception_list_update (p_ceid collection_entities.ceid%TYPE,
                                            p_idusr users.idusr%TYPE
                                            )
        IS 
        v_idusr users.idusr%TYPE;
        v_ceid collection_entities.ceid%TYPE;

        BEGIN
          INSERT INTO pa_exception_list(pa_exception_list_id,
                                        ceid,
                                        creation_date,
                                        created_by)
          VALUES(pa_exception_list_seq.nextval, p_ceid, SYSDATE, p_idusr);
        END Pa_exception_list_update;

Usually the script starts with "create or replace procedure...". — Rene
This procedure is part of a large package which starts with this statement. — h0neybaLL
So maybe the problem is elsewhere in that package? Maybe you are calling the procedure before it has been declared? — Rene
+1, as the only 2 places where PA_EXCEPTION_LIST_UPDATE is mentioned are at CREATE and END procedure. Therefore, it must be somewhere else. — Littlefoot
Also check out the answer to this question: stackoverflow.com/questions/42722228/… — alexs

Rene Rene · Accepted Answer · 2018-01-15T09:16:47

It looks like you are calling the procedure before it has been declared.

Look at this example. Procedure A calls procedure B. But B is unknown at that moment.

create or replace package test is
begin
end test;

create or replace package body test is
procedure a
is
begin 
  b;
end;


procedure b is
begin
  -- do someting
end;

end test;

Solution. Change the order of the procedures within the package or place the procedure in the package specification.

create or replace package test is
begin
  procedure b;
end test;

create or replace package body test is
procedure a
is
begin 
  b;
end;


procedure b is
begin
  -- do someting
end;

end test;

Component must be declared error (ORA-06550)

4 Answers