title: PL/SQL anonymous block completed with no result displayed
body: <p>When I execute the procedure nth would appear except the following message and not showing any output which should not be the case: anonymous block completed</p>
  
  <p>I've tried to <code>set serveroutput on size 50000</code> but nothing changes. </p>
  
  <p>Here's my PL/SQL procedure not sure if i'm doing it right.</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE verify AS
    empnum  NUMBER;
    empname VARCHAR2(50);
    fail EXCEPTION;
  BEGIN
  
    SELECT employee.e#, employee.name INTO empnum, empname
      FROM employee
      JOIN driver ON driver.e# = employee.e#
      JOIN mechanic ON mechanic.e# = driver.e#
     WHERE rownum = 1;
  
  EXCEPTION
    WHEN no_data_found THEN
      dbms_output.put_line('ok');
      RAISE fail;
  END verify;
  /
  </code></pre>
  
  <p>I'm trying to achieve the following result in using sql statement:</p>
  
  <pre><code>  SELECT employee.e#, employee.name
      FROM employee
      JOIN driver ON driver.e# = employee.e#
      JOIN mechanic ON mechanic.e# = driver.e#
     WHERE rownum = 1;
  </code></pre>
  
  <p>So if there's any similar records it will show the employee name and num. If there's no similar records found it will display a <code>ok</code> message. </p>