SQL -- getting values

Hi all,
Im running Oracle 9i on a Win2000 machine. I have a table which stores the semester for a university. In most of my sql queries im having to hard code the semester example:

Select *
from enrollment
where semester = 013........

The problem is that in my next semster i will have to go and change all these SQL statements, which might be embedded in my XSQL pages, et al.
Is there a way in which i could call a Procedure in my sql statement which would, depending on the SYSDATE calculate the current semster. I can make this procedure without any fuss..... but dont know how to put it in the where clause in SQL.
Is there any other way i could put in the semster dynamically ?

Help will be much appreciated.
Regards,
Girish Received on Thu Nov 08 2001 - 02:06:34 CET