错误存储过程 ORA-06550

我使用此代码获取编译错误 sqlplus.

我的错误是:

警告:使用汇编错误创建的过程。

BEGIN point_triangle; END;

字符串错误 1: ORA-06550: 线 1, 柱子 7:

PLS-00905: 一个东西 POINT_TRIANGLE 不可受理

ORA-06550: 线 1, 扬声器 7:

陈述 PL/SQL 忽略了

每当我获得的时候 show errors, 他告诉我没有错误。

这是此代码。


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


假设所有球员在这支球队中的职业生涯中的所有球员都属于 C. 我知道请求只在程序中工作。
已邀请:

奔跑吧少年

赞同来自:

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

八刀丁二

赞同来自:

你能试试这个:


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;

要回复问题请先登录注册