Thanks.

I'm having a look now at using OBJECTs and TABLEs and the OTT tool. Maybe I can return a TABLE from a stored procedure. However, I'd rather not have to do the whole OCI thing as it looks a lot more complex than regular Pro*C.

The other option someone suggested was returning a reference to a cursor.