Re: parameters in query

From: Tom <mail_at_yahoo.com>
Date: Thu, 7 Apr 2005 14:31:32 +0200
Message-ID: <d3397r$m4c$1@ss405.t-com.hr>

I need suptitution of bind variables...

i'm runnig query in T.O.A.D so after execution query

      select * from order where id_order in (:id_order) in variable window i pick in Type box Substitution (instead of String) and in Value box i type 1,5,9
query execute right!!!!
but how did i run this query throug sqlplus or other program through sqlplus i wrote:

            variable id_order number
            /
            exec :id_order := 1
            /
            select * from order where id_order  in (:id_order)

sql returns only id_order = 1

i think that problem is maybe with declaration of bind variable...

"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 - 07:31:32 CDT