Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!r34g2000hsd.googlegroups.com!not-for-mail
From:  sfauchille@gmail.com
Newsgroups: comp.databases.oracle.misc
Subject: Stored procedure parameter
Followup-To: comp.databases.oracle.misc
Date: Wed, 08 Aug 2007 01:57:44 -0700
Organization: http://groups.google.com
Lines: 27
Message-ID: <1186563464.348036.314900@r34g2000hsd.googlegroups.com>
NNTP-Posting-Host: 80.118.39.193
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1186563464 20932 127.0.0.1 (8 Aug 2007 08:57:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 8 Aug 2007 08:57:44 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: r34g2000hsd.googlegroups.com; posting-host=80.118.39.193;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.misc:249152
X-Received-Date: Wed, 08 Aug 2007 10:40:21 EDT (text.usenetserver.com)

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 :