Re: Stored procedure parameter

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 08 Aug 2007 11:19:43 -0700
Message-ID: <1186597181.380502@bubbleator.drizzle.com>

sfauchille_at_gmail.com wrote:

> 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 :

> 
> - 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

Are you using the native Oracle driver or ODBC?

Crystal has no problem running Oracle stored procedures. Just make sure your stored procedure parameters are all IN OUT.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Aug 08 2007 - 13:19:43 CDT