plsql - how to by pass the need for dynamic sql
Posted on 2012-03-19
On Oracle 10.2
I am looking for a way to write a plsql procedure without the use of dynamic SQL.
Inside I need to add a where clause with a parameter that is actually a concatinated list of values:
proedure foo (p_list in varchar2) is
select field1,field2, field3...
where id in (p_list) ; -- This is the dilema!!!
The procedure is being called like this:
I know how to do it with dynamic SQL, looking for a way to avoid it.