Re: Retrieving complex resultset from oracle

If you don't want to look up ref cursor in the documentation I would gladly write this stored procedure for you. My going rate is $100 per hour in US currency.
Jim
"Josh" <jr8110_at_yahoo.com> wrote in message news:a1c10eb3.0210080956.60bf15d0_at_posting.google.com...
> 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 Wed Oct 09 2002 - 03:19:08 CEST