Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!22g2000hsm.googlegroups.com!not-for-mail
From:  sybrandb <sybrandb@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Stored procedure parameter
Date: Wed, 08 Aug 2007 02:48:55 -0700
Organization: http://groups.google.com
Lines: 40
Message-ID: <1186566535.482562.325350@22g2000hsm.googlegroups.com>
References: <1186565589.969375.297460@22g2000hsm.googlegroups.com>
NNTP-Posting-Host: 192.33.238.6
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1186566535 17803 127.0.0.1 (8 Aug 2007 09:48:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 8 Aug 2007 09:48:55 +0000 (UTC)
In-Reply-To: <1186565589.969375.297460@22g2000hsm.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ;  Embedded Web Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 PXYBEBR003
Complaints-To: groups-abuse@google.com
Injection-Info: 22g2000hsm.googlegroups.com; posting-host=192.33.238.6;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.server:432626
X-Received-Date: Wed, 08 Aug 2007 10:42:30 EDT (text.usenetserver.com)

On Aug 8, 11:33 am, "sfauchi...@gmail.com" <sfauchi...@gmail.com>
wrote:
> Hello,
>
> Sorry for my english, i'll try to explain my problem
>
> I'm working with Crystal Report X and i call a oracle stored
> procedure.
>
> One of the parameter (ListOfPoint) of crystal is a multi value (id of
> a table)
>
> In the Stored procedure i'd like to get this parameter to do something
> like that :
>
> CREATE OR REPLACE  PROCEDURE MyPrc
> (ListOfPoint in ?????? ) AS
>
> BEGIN
>
> SELECT col1,col2 FROM MyTable WHERE Col3 in (ListOfPoint)
>
> END;
>
> Do you have an idea??
>
> I tried this :
>
> - in crystal, convert the list of parameter ListofPoint into string by
> a join to get a "1,2,3"
> - in the stored procedure declare the ListOfPoint into varchar2 but
> the select do not work because Col3 is a number

Search for 'Dynamic IN list' on http://asktom.oracle.com

Hth
--
Sybrand Bakker
Senior Oracle DBA