Stored procedure record types

How does one get a pl/sql record as output for an adapter? Using a regular call, I recieve an ORA-00902: Invalid data type.

Also, is it possible to get multiple ‘rows’ of records (as in a table)?