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: Stored procedure parameter

Re: Stored procedure parameter

From: Florian Reiser <florian.reiser_at_ra-bc.de>
Date: Wed, 8 Aug 2007 11:31:04 +0200
Message-ID: <46b98d5a$1@news.arcor-ip.de>


Hello sfauchille,

in the stored procedure you first have to parse your string and convert the elements back to numbers again.

With kind regards
Florian Reiser
http://www.ra-bc.de

<sfauchille_at_gmail.com> schrieb im Newsbeitrag news:1186563705.954644.164850_at_l70g2000hse.googlegroups.com... On 8 août, 10:57, 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 :

but the select do not work because Col3 is a number Received on Wed Aug 08 2007 - 04:31:04 CDT

Original text of this message

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