Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: a view with parameters ?

Re: a view with parameters ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 03 Dec 1999 19:50:09 +0800
Message-ID: <3847AE70.6B97@yahoo.com>


Marcel de Haan wrote:
>
> Hello
>
> I am having a view that unions 4 queries. But also need some criteria, to
> limit these records.
>
> I want to use parameters. I am using the view from within a stored
> procedure.
> Can i make this work somehow ?
>
> Hope someone can help.
>
> Best regards
>
> Marcel

Define the view with the where clause referencing functions that return package variables. Then you just adjust the package variables as required.

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Dec 03 1999 - 05:50:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US