title: How to create a filter in SQL through a procedure or function?
body: <p>I've tried to do it like this:</p>
  
  <pre class="lang-sql prettyprint-override"><code>-- RF-001 Informe de ventas por cliente
  CREATE OR REPLACE PROCEDURE Ventas_cliente( DNI IN CHAR )
  IS
  
  BEGIN 
    SELECT * FROM Pedidos_venta
    WHERE DNI_Cliente = DNI;
  END Ventas_cliente;
  </code></pre>
  
  <p>When I run it, SQL Developer returns the next error: </p>
  
  <blockquote>
    <p>Error(5,3): PLS-00428: an INTO clause is expected in this SELECT
    statement</p>
  </blockquote>
  
  <p>Why is INTO needed to filter in this ocasion? How should I do?</p>