Thanks for your reply James.

But in your example you know the columns that a being passed to the procedure.

I need to have a generic where clause, meaning I don't know the number of columns or which columns will be passed to the procedure.
In other words, a user will be passing a string that can have different columns and values.
Here are the examples of something a user can pass.

'commission is null'
'empno = 4 and deptno = 10'
'empname = 'SMITH''