Nick Upson wrote:

>
> should I expect it to work if I do something like
>
> stmt = 'select count(*) from .....NOT IN (' || str || ')'
> execute immediate stmt
>

Yes - that's what you have to do. The processing involved
in preparing a statement identifies certain lexical elements -
including the elements in the IN list. You can replace values
after a statement is prepared, but not keywords, field or table
names, comparison operators, etc., and the in list is one of
the things that can't be changed.


Regards,


Ann