"Ernest Morariu" <ernest_at_gesora.com> wrote in message
news:cfan02$eom$1_at_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
> >
> >
>
>
Nope. Each session is separate from each other. One does not effect the
other.
Jim
Received on Tue Aug 10 2004 - 10:20:52 CDT
