parametrized Views or use of PL/SQL procedures in queries

From: Michael Dahlinger <M.Dahlinger_at_gsi.de>
Date: 18 Jun 1998 09:31:10 GMT
Message-ID: <01bd9a9c$1ef39ee0$8f68b58c@depc14>

Hello,
I am trying to implemet a complex query over many tables, which involves also a query, wher a parameter must be given at the beginning (the requested version).

For testing purposes, I designed my queries with MS Acess and Oracle Browser. In both applications I have the possibility to define a query dependend of a parameter. In MS Access I can use this query later in other queries. This is exactly what I want, but then the query runs in my client application.
Due to the complexity of the query, the query should run in the database server, however.

How can I realize this in Oracle. I would like to create a VIEW, which selects other tables and views and *parametrized queries*. I am aware of the fact that I can write a Procedure which returns a Cursor, but how can I use the results of this proceduer in subsequent VIEWS?

Any hints would be appreciated !

My best regards
Michael Dahlinger

begin 600 Signature.txt
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0I$<BX_at_36EC:&%E M;"!$86AL:6YG97(@("!496PN.B H*S0Y*2TP-C$U.2TW,2TR-30V(" @( T* M1U-)(&-O;7!U=&EN9R!D97!T+B @(" @1D%8(#H@*"LT.2DM,#8Q-3DM-S$M M,CDX-_at_T*4&QA;F-K<W1R+B Q(" @(" @(" @(" @(" @(" @(" @(" @(" @

M(" @(" @(" @96UA:6PZ#0I$+38T,CDQ($1A<FUS=&%D=" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @("!-+D1A:&QI;F=E<D!G<VDN9&4-"D=E<FUA
M;GD@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*

M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM C+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0HM `
end Received on Thu Jun 18 1998 - 04:31:10 CDT