› Fóruns › SQL e PL/SQL › Erro em Procedure › Erro em Procedure
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