Re: Retrieving complex resultset from oracle

Its rather difficult for me to elaborate more, the best i can do is give some sorta pseudo code related to my problem, the query would be something along the lines of this

Lets say i have 1 parameter, _at_report_date of type DATE, i'd like to do something along the following:

SELECT a.id, a.amount, b.description
FROM table1 a, table2 b
WHERE a.id = b.id
AND a.date = _at_report_date

And whatever results from that is what i'd like to use in either MS Access or Crystal Reports. I just need some sorta skeletal example of how to get the resultset out, and how to grab it in my app.

Thanks Received on Tue Oct 08 2002 - 19:56:59 CEST