Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored procedure parameter
On Aug 8, 11:33 am, "sfauchi..._at_gmail.com" <sfauchi..._at_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 DBAReceived on Wed Aug 08 2007 - 04:48:55 CDT