oracle error ora-1795

I am creating my select statement depending on my users input. The users have a choice to enter a range. If the range is entered the select statements where claues is " between the two values entered. " Is there a better way to do this. Received on Sun Jun 07 1998 - 14:29:34 CDT