Stored Procedure error ORA-06550

Question

I m getting compile errors with this code using sqlplus   My errors are      Warning  Procedure created with compilation errors       BEGIN point triangle  END       Error at line 1  ORA-06550  Line 1  column 7    PLS-00905  object POINT TRIANGLE is invalid   ORA-06550  line 1  column 7    PL SQL Statement ignored   Whenever I type show errors  it tells me there are no errors   Here is the code   create or replace procedure point triangle AS A VARCHAR2 30   B VARCHAR2 30   C INT  BEGIN FOR thisteam in  select P FIRSTNAME into A from PLAYERREGULARSEASON P where P TEAM    IND  group by P FIRSTNAME  P LASTNAME order by SUM P PTS  DESC                   select P LASTNAME into B from PLAYERREGULARSEASON P where P TEAM    IND  group by P FIRSTNAME  P LASTNAME order by SUM P PTS  DESC                   select SUM P PTS  into C from PLAYERREGULARSEASON P where P TEAM    IND  group by P FIRSTNAME  P LASTNAME order by SUM P PTS  DESC   LOOP     dbms output put line A          B           C   END LOOP   END      it is suppose to put all the players into A and B with their points of their career on that team into the C  I know the queries work  just not in the procedure

User · Accepted Answer

create or replace procedure point triangle AS BEGIN FOR thisteam in  select FIRSTNAME LASTNAME SUM PTS   from PLAYERREGULARSEASON  where TEAM       IND  group by FIRSTNAME  LASTNAME order by SUM PTS  DESC   LOOP dbms output put line thisteam FIRSTNAME          thisteam LASTNAME           thisteam PTS   END LOOP   END

User · Answer

Could you try this one   create or replace  procedure point triangle IS BEGIN   FOR thisteam in  select P FIRSTNAME P LASTNAME  SUM P PTS  S from PLAYERREGULARSEASON P  where P TEAM    IND   group by P FIRSTNAME  P LASTNAME order by SUM P PTS  DESC    LOOP     dbms output put line thisteam FIRSTNAME          thisteam LASTNAME            thisteam S     END LOOP   END

[sql] Stored Procedure error ORA-06550

Examples related to sql

Examples related to oracle

Examples related to stored-procedures

Examples related to ora-06550