ref cursor in oracle

 My developer is writing a web application using VB. One of the section has a drop down menu and the data for the drop down menu comes from six different tables. So, I think creating a view is out of question. If have the developer open the database connection six times during the process, it is not efficient. I am thinking of achieving this with a procedure using ref cursors. I know I can fetch data from one table to the ref cursor to return the recordset. But is it possible to return the data from six different tables into