Re: parameterized views

From: Ernest Morariu <ernest_at_gesora.com>
Date: Tue, 10 Aug 2004 16:44:15 +0200
Message-ID: <cfan02$eom$1@carabinieri.cs.interbusiness.it>

Mark,

thank you for your answer !

The solution you suggested suposes two steps : one to set the value of the parameter and another one to open the view. I think there is the risk that an user extracts data using the value of the parameter set by another user(I mean not the one he/she sets ). What do you think about ?

ernest

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:b9udnSI6eIxDSIXcRVn-qw_at_comcast.com...
>
> "Ernest Morariu" <ernest_at_gesora.com> wrote in message
> news:cfaj7g$71r$1_at_fata.cs.interbusiness.it...
> | Hi !
> |
> | Is it possible in Oracle to create a parameterized view ?
> |
> | ernest
> |
> |
>
> yes, by referencing a package variable (or function) in the where clause,
> and setting the package variable (or populating appropriate rows in
control
> tables) prior to SELECTing from the view
>
> ++ mcs
>
>
Received on Tue Aug 10 2004 - 09:44:15 CDT