Re: parameters in query

Tom wrote:
> i have lot of problems with letter query:
>
>
> select * from order where id_order in (1,5,9)
>
> oracle execute this query without problems, but
>
> select * from order where id_order in (:id_order)
>
> parametar is 1,5,9 oracle returns error
>
> any idea??

If I understand what you are trying to do there is a very simple solution.

http://www.psoug.org
click on Morgan's Library
click on Conditions
scroll down to the "Complex IN Demo" using CAST

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)