title: creating a procedure for nested tables
body: <p>The following codes successfully creates a procedure using sql*plus</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE input_order (pat_id in char, vis_vdate in date, vis_act in number,  
   vac_vacc in char)
  AS
  BEGIN
  DBMS_OUTPUT.PUT_LINE ('Insert attempted');
  insert into vaccinations(pid,vdate,action,vaccinated) values(pat_id,vis_vdate,vis_act,vac_vacc);
  DBMS_OUTPUT.PUT_LINE ('Insert succeeded');
  EXCEPTION
  WHEN others THEN DBMS_OUTPUT.PUT_LINE ('error');
  DBMS_OUTPUT.PUT_LINE ('Insert rejected');
  END;
  /
  </code></pre>
  
  <p>However my intension is to create a similar procedure which includes populating a nested table as  an attribute of a table</p>
  
  <ul>
  <li>for example: supposing 'vis_act' is a nested table </li>
  <li>with type vis_set_t</li>
  <li>and attributes visname and visurname</li>
  </ul>
  
  <p>i tried it this way but kept getting errors</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE input_order (pat_id in char, vis_vdate in date, vis_act in 
  vis_set_t, vac_vacc in char)
  AS
  BEGIN
  DBMS_OUTPUT.PUT_LINE ('Insert attempted');
  insert into vaccinations(pid,vdate,vis_set_t(visname,visurname),vaccinated) values
  (pat_id,vis_vdate,vis_act,vac_vacc);
  DBMS_OUTPUT.PUT_LINE ('Insert succeeded');
  EXCEPTION
  WHEN others THEN DBMS_OUTPUT.PUT_LINE ('error');
  DBMS_OUTPUT.PUT_LINE ('Insert rejected');
  END;
  /
  </code></pre>