Re: Procedure with multiple where clauses

"Wezzzzap" <_no_spam_at_pi.be> wrote in news:a748kj$60f$1_at_reader06.wxs.nl:

> Hey,
>
> I'm searching for a solution for the next problem :
>
> We want to create a 'dynamic procedure' that could be used for multiple
> search operations.
>
> So we give multiple paramaters to the procedure -- not every parameter
> will be used -- and in the procedure we
> have a select with a where clause that is created from the parameters
> that are filled in ...
>
> Is there a solution ?
>
> kind reg.

Use the DBMS_SQL package. You can construct "select" commands (or any SQL commands) within the code and then use DBMS_SQL to execute them.

-- 
Ken Denny
http://www.kendenny.com/

The power of accurate observation is commonly called cynicism by those who 
have not got it.