title: Oracle PL/SQL: Forwarding whole row to procedure from a trigger
body: <p>In have an Oracle (10i) PL/SQL Row-Level trigger which is responsible for three independent tasks. As the trigger is relatively cluttered that way, I want to export these three tasks into three stored procedures.
  I was thinking of using a <code>my_table%ROWTYPE</code> parameter or maybe a collection type for the procedures, but my main concern is how to fill these parameters.</p>
  
  <p>Is there a way to put the whole <code>:NEW</code> row of a trigger into a single variable easily? 
  So far the only way I could find out was assigning each field separately to the variable which is not quite satisfying, looking at code maintenance etc.</p>
  
  <p>Something like</p>
  
  <pre><code>SELECT :NEW.* INTO &lt;variable&gt; FROM dual;
  </code></pre>
  
  <p>would be preferred. (I haven't tried that actually but I suppose it wouldn't work)</p>