title: Stored Procedure Select
body: <p>Well, i've been trying to built a SP in order to help me get all the fields from a table called TIKEt here is my table TIKET:</p>
  
  <pre>TABLE TIKET: 
  IDTIKET    TYPE NUMBER
  NOMBRE   TYPE VARCHAR2
  EDITORIAL TYPE VARCHAR2
  AUTOR  TYPE VARCHAR2
  EDICION  TYPE VARCHAR2
  PRECIO  TYPE NUMBER
  CANTIDAD TYPE NUMBER,
  FECHA  TYPE DATE default sysdate
  NOMBRE_USER  TYPE VARCHAR2</pre>
  
  <p>and here it's my SP code:</p>
  
  <pre><code>`create or replace procedure get_tiket
  (
   idtiket_ out number,
   nombres_ out varchar2,
   editorial_ out varchar2,
   autor_ out varchar2,
   edicion_ out varchar2,
   precio_ out number,
   cantidad_ out number,
   fecha_ out date,
   nombre_user_ in varchar2
  )
  is 
  begin
  select idtiket, nombre, editorial, autor, edicion, precio, cantidad, fecha into idtiket_, nombres_, editorial_, autor_, edicion_, precio_, cantidad_, fecha_ from tiket
  where nombre_user=nombre_user_;
  end;
  </code></pre>
  
  <p>/`</p>
  
  <p>When i run this code in SQLPLus says: "Procedure Created" which i think means it's ok right? But when i called this Sp: exec get_tiket('ale'); it gives me this error:</p>
  
  <pre><code>call get_tiket('ale');
  </code></pre>
  
  <blockquote>
    <p>ERROR at line 1:</p>
    
    <p>ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_TIKET'</p>
  </blockquote>
  
  <p>What i want is to get all the fields from table TIKET depending on the user i need! Please thanks for your help ahead!</p>