SQL & PL/SQL

Hi,

Is it possible to pass a parameter to a stored procedure containing a text
string that you can use with where clause in the stored procedure (Oracle)?

In my store procedure select statement is look like this:

Select * from t_absence where duration > '20'

How Can i pass ( duration > '20' ) as a parameter or just ( > ) sign in parameter? Can anyone help pls?

In my application there is drop down menu which contains >,>=,<,<= signs and next to that there is text box where user can input values and i want to pass signs (>,>=,<,<=) depends on user selection and text values to store procedure.

I know how to write normal store procedure with parameters but don't know how to write select query inside procedure which can accept values as mentioned above.



Thanks

Edited by: user10878991 on Feb 22, 2009 9:07 AM