Re: Retrieving complex resultset from oracle

Yes it is possible. You can use REF cursors and procedure which will take paraeters and return a REF cursor.
But as you didn't tell much more about your situation I can't give you more clues.

iulian

"Josh" <jr8110_at_yahoo.com> wrote in message news:a1c10eb3.0210071306.2f47ba7b_at_posting.google.com...
> I have a question about something that is driving me nuts
>
> What I want to do is create a procedure or whatever you want to call
> it to return me a result set of a select statement that has one
> parameter, a date, that will do a join on 2 tables and filter it by
> the date i specify.
>
> I would like to use the resultset from this select statement in 3rd
> party apps, such as Microsoft Access or Crystal Reports, so i don't
> want to simply cut and paste the Select statement into these apps
> using their query builders, I want some sort of procedure that will
> take the date parameter and spit me out my resultset.
>
> Is this possible in Oracle, version 8.1.5
>
> I've thought of using a View, but i don't think i can create a view
> inside a procedure from what i've read.
Received on Tue Oct 08 2002 - 03:14:17 CEST