Before I have a go at hacking it together I wanted to check: Has anyone explored modifying crosstab to return a refcursor, so you can FETCH the results w/o having to specify an explicit result type/descriptor?
+1
Consuming the input in another query is more of a pain, but it'd be infinitely nicer when you just want the results in a client.