title: SQL Developer Oracle, how to call procedure?
body: <p>I have delcared function like this:   </p>
  
  <pre><code>CREATE or replace PROCEDURE proc
  (
    P_ID IN INTEGER,
    NAME OUT CHAR,
    SURNAME OUT CHAR,
    TOTAL OUT CHAR
  )
   AS
      BEGIN
          SELECT NAME, SURNAME, sum(TOTAL) AS TOT
            INTO NAME,SURNAME,TOTAL
            FROM STATISTICS, PLAYERS, PERSON
            WHERE STATISTICS.SID=P_ID AND PERSON.ID=PLAYERS.SID AND      
            STATISTICS.PLAYERS_SID=PLAYERS.SID
          GROUP BY NAME,SURNAME;
  END;
  </code></pre>
  
  <p>Select statement works corectly, but how to call this procedure in Oracle?</p>
  
  <p>I tried something like</p>
  
  <pre><code>EXEC proc(4);
  </code></pre>
  
  <p>AND</p>
  
  <pre><code>DECLARE
    NAME OUT CHAR,
    SURNAME OUT CHAR,
    TOTAL OUT CHAR
  
  BEGIN
     P_ID := 12 ;
     proc (
     P_ID =&gt; P_ID,
     NAME =&gt; NAME,    
     SURNAME =&gt; SURNAME,
     TOTAL =&gt; TOTAL
  );
  END;
  </code></pre>
  
  <p>but without any success.</p>