You can call a database function in your query. That function can make use
of a package variable if the function is in a package. You can set the
package variable beforehand and then use the view. Each user will get
different rows from the view depending on the value of the package variable
you have set at runtime. This is how we do it from Oracle forms etc.
I am not aware of Access functionality.
Regards,
--
Shariq
Shariq's home page http://www.angelfire.com/az/sharp/
Benjamin Verdenik <benjamin.verdenik_at_talum.si> wrote in message
news:374E88BA.CC9222DB_at_talum.si...
> Hi,
>
> Can I create a VIEW in oracle7 that have a parameter ? How can I
> associate a value to the paramater when I call this VIEW from Microsoft
> Access.
>
> Thanks in advance
> Benjamin Verdenik
>
Received on Fri Jun 11 1999 - 08:30:46 CDT
