Home -> Usenet -> comp.databases.oracle -> Retrieving complex resultset from oracle

Retrieving complex resultset from oracle

From: Josh <jr8110_at_yahoo.com>
Date: 7 Oct 2002 14:06:20 -0700
Message-ID: <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 Mon Oct 07 2002 - 23:06:20 CEST












Original text of this message