If you're using a SPROC, try using OUT modifiers to retrieve data. This assumes you're doing this because you have control over and familiarity with Oracle. You can use a View in place of a table for repeatable queries, then you know what's being returned.
If you want to generate dynamic queries, no matter whether you use Native or a Sproc to call Oracle, you'll need to do some heavy-lifting to parse the response data. Although I haven't tested this, I'd suggest a sproc that returns XML. This could be interesting. J