Oracle : View with a parameter

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by GerardMcL 0n 13 January 2009

I have to bring a load of queries from Access over to Oracle and Im trying to simply put them in as Views.
One in particular needs a parameter passed in but I get an error about not being allowed to use bind variables.

Does anyone know a way to do this?
Your help as always is greatly appreciated.

Learn more about Oracle databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting