Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: a view with parameters ?
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
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Dec 03 1999 - 05:50:09 CST
![]() |
![]() |