Re: stored procedures & parameters

You can use the built-in dbms_sql - package to dynamically build up and execute sql in your procedures.

matthias

Ian L schrieb:
>
> I'm new to Oracle and not at all sure how to do the following:
>
> I want to pass in various parameters to a stored procedure and use them as
> search criteria in a select statement (so far so good), the problem is that
> I may not want to use all the parameters depending on the data being passed
> in. For example if I pass in a zero value to one parameter then I do not
> want to include that section of the where clause. Can I dynamically build up
> the select statement in a stored procedure?
>
> Many thanks for your help in advance.
>
> Ian
Received on Tue Apr 24 2001 - 02:49:51 CDT