title: Oracle: Variable number of parameters to a stored procedure
body: <p>I want to INSERT various users into a Oracle db with a stored procedure. A user (table "user") has, say, name, surname and date of birth:</p>
  
  <pre><code>CREATE TABLE "USER" 
     (
     "Name" VARCHAR2(50),
     "Surname" VARCHAR2(50),
     "Dt_Birth" DATE,
     )
  </code></pre>
  
  <p>A stored procedure to create a user is pretty simple:</p>
  
  <pre><code>CREATE PROCEDURE Insert_User(p_user, p_surname, p_dt_birth)
  BEGIN
   INSERT INTO User(Name, Surname, Dt_Birth) VALUES(p_user, p_surname, p_dt_birth);
  END;
  </code></pre>
  
  <p>What if I want to create a stored procedure to insert a variable (1 or 2 or 3 etc) number of users? Thanks</p>
  
  <p><em>Also, please note that the above code is just for sample, so random incorrect bits may be present</em></p>