title: Returning multiple values after insert
body: <p>I got this 'Message' table.</p>
  
  <pre><code>CREATE TABLE message (
      id INT PRIMARY KEY,
      user_id INT NOT NULL REFERENCES users (id) ON DELETE CASCADE,
      category_id INT NOT NULL REFERENCES category (id) ON DELETE CASCADE,
      text VARCHAR2(4000),
      media VARCHAR2(500),
      creation_date DATE DEFAULT SYSDATE
  );
  
  CREATE SEQUENCE message_seq;
  CREATE OR REPLACE TRIGGER message_bir 
  BEFORE INSERT ON message
  FOR EACH ROW
  
  BEGIN
    SELECT message_seq.NEXTVAL
    INTO   :new.id
    FROM   dual;
  END;
  </code></pre>
  
  <p>After i insert something i need the last inserted id and the date.</p>
  
  <pre><code>INSERT INTO message (user_id, category_id, media)
  VALUES (1, 1, 'fdsfsd')
  RETURNING id INTO :last_insert_id
  </code></pre>
  
  <p>The above gives me the last inserted id, but like i said i also need the creation_date. I dont want to do a select query after...</p>
  
  <p>Is there a way to get 2 values back after run an insert?</p>