Pular para o conteúdo

Fóruns SQL e PL/SQL Erro em Procedure Erro em Procedure

#86449
mpvargas
Participante

    David,
    Fiz conforme sua dica e deu o seguinte erro:

    SQL> SET VERIFY OFF;
    SQL> SET SERVEROUTPUT ON;

    SQL> DECLARE
    2 CURSOR DBA_CUR IS
    3 SELECT NOME,CAMPUS,CODCURSO,CPF
    4 FROM MSIGA.PROC1;
    5 pNOME VARCHAR2(30);
    6 pCAMPUS VARCHAR2(50);
    7 pCODCURSO NUMBER;
    8 pCPF VARCHAR2(15);
    9 BEGIN
    10 OPEN DBA_CUR;
    11 FETCH DBA_CUR INTO pNOME,pCAMPUS,pCODCURSO,pCPF;
    12 CLOSE DBA_CUR;
    13 DBMS_OUTPUT.PUT_LINE(1000,:pNOME,:pCAMPUS,:pCODCURSO,:pCPF);
    14 END;
    15 /
    DBMS_OUTPUT.PUT_LINE(1000,:pNOME,:pCAMPUS,:pCODCURSO,:pCPF);
    *
    ERROR at line 16:
    ORA-06550: line 16, column 7:
    PLS-00306: wrong number or types of arguments in call to ‘PUT_LINE’
    ORA-06550: line 16, column 7:
    PL/SQL: Statement ignored