Parametric Views

renato · **Joined:** Tue Dec 09, 2003 10:43 am **Posts:** 7

Is there any way to use parametric views with Hibernate on an Oracle DB?
Any hint will be very appreciated

Renato

christian · **Posted:** Thu May 27, 2004 9:37 am

AFAIR Oracle doesn't support parameterized views at all? I remember that you can use a stored package value and set it before accessing your view with a storec procedure call...

Google turned up this:

http://asktom.oracle.com/pls/ask/f?p=49 ... 0800568535,

baliukas · **Posted:** Thu May 27, 2004 3:30 pm

A standard way to store session parameters is a temprory table. I am not sure it works for view (view will depend on temprory object ), but some fake table must help.