Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: parameters in query

Re: parameters in query

From: Tom <mail_at_yahoo.com>
Date: Sat, 9 Apr 2005 10:54:45 +0200
Message-ID: <d3859d$47j$1@ss405.t-com.hr>


OK
i read about CAST function and seems i have problem with converting string '1,5,9'

        select * from order where id_order in ( cast (:id_order) as InStrTab)..
probably syntax isn't right or there is incompatible data types

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1112997520.564158_at_yasure...
> 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)
Received on Sat Apr 09 2005 - 03:54:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US