Error After executing procedure: no output

0

Code

CREATE OR REPLACE PROCEDURE buscaturma(cod NUMBER) AS
  nomeT varchar2(20);
BEGIN

  IF (cod=0)then
    dbms_output.put_line('ZERO');
  ELSE
    SELECT DS_TURMA 
     into nomeT
    FROM TURMA
    WHERE CD_TURMA = cod;

    dbms_output.put_line('NOME: '||nomeT);

  END IF;

EXCEPTION
    WHEN OTHERS THEN
        dbms_output.put_line('Não foi possível verificar');

END;

Run procedure

EXECUTE buscaturma(13);

EXPECTATION:

  

'NAME:' || nameT

EXIT:

    
asked by anonymous 23.01.2018 / 15:04

1 answer

1

No Sql Developer

Menu
  Exibir
     Saída DBMS
       Botão **+**  
         Escolher conexão 

In this window the outputs will be displayed.

    
23.01.2018 / 15:47