错误存储过程 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. 我知道请求只在程序中工作。
2021-03-20 添加评论
分享

没有找到相关结果

    已邀请:

    奔跑吧少年

    赞同来自: 

    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;
    
/
    2021-03-20 0 0
    分享

    八刀丁二

    赞同来自:

    你能试试这个：


    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;
    2021-03-20 0 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册

    Copyright © 2023, All Rights Reserved