Input sql query and output result set in table types

Hi Guru's,

My requirement is i need to write a procedure which accepts input a SQL query and output will the result set of the query. Output columns will be static.

example input query is

select lookup_type,

                      lookup_code,

                       meaning     ,

                       description

                       from fnd_lookup_values where rownum<10

I'm pretty new to plsql and i'm unable to achieve this. Any help will be appreciated.