Re: parameters in query

and you need to read my question again...

Every time I want to write diferent value of parameter..

once, for example id_order = 1 and id_order = 5 and id_order = 9  I need to display order number 1, number 5, number 9.. understand??!!...

        select * from order where id_order in (1,5,9) further

        select * from order where id_order in (1,6,17,89) further

        select * from order where id_order in (2,15,28,150)

now, instead of writing (1,5,9) in query , (1,6,17,89), (2,15,28,150)...i want to use parameter

     select * from order where id_order in (:id_order) after execution i input value 1,5,9 for parameter and error ORA-01722 and ORA-02063 occurs...

in your example i need to input value for :id_order...what should i write? 1? 1,5,9 ??

"Alan" <not.me_at_uhuh.rcn.com> wrote in message news:N385e.451$Zn3.351_at_trnddc02...
> You need to get a book that teaches your SQL, or read the one you have.
>
> select * from order where id_order in (SELECT :id_order FROM ...)
>
>
> "Tom" <mail_at_yahoo.com> wrote in message
> news:d331c9$6la$1_at_ss405.t-com.hr...
>> 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??
>>
>>
>>
>
>
Received on Thu Apr 07 2005 - 06:25:21 CDT