title: Query pl/sql record type in a simple sql
body: <p>I have a function in a package and it returns a user-defined record.</p>
  
  <p>The record looks like:</p>
  
  <pre><code>type MyRecord is record (
      id varchar(15),
      start_date date
  );
  </code></pre>
  
  <p>i want to call my function in a sql query. i tried this:</p>
  
  <pre><code>select id, start_date from (select mypackage.myfunc() from dual);
  </code></pre>
  
  <p>But it doesn't work. The main question is how can i call a stored function from a simple sql query. Any idea?</p>