Re: Stored procedure parameter

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 10 Aug 2007 08:39:30 -0700
Message-ID: <1186760370.355857@bubbleator.drizzle.com>

sfauchille_at_gmail.com wrote:

> On 9 août, 17:25, DA Morgan <damor..._at_psoug.org> wrote:

>> Florian Reiser wrote:
>>> 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
>> No you don't. You can use CAST. Here's one example:
>>
>> conn scott/tiger
>>
>> CREATE OR REPLACE TYPE InStrTab IS TABLE OF VARCHAR2(20);
>> /
>>
>> set serveroutput on
>>
>> DECLARE
>> i PLS_INTEGER;
>> x InStrTab := InStrTab('10','30');
>> BEGIN
>> SELECT COUNT(*)
>> INTO i
>> FROM emp
>> WHERE deptno IN (
>> SELECT column_value
>> FROM TABLE(CAST(x AS InStrTab)));
>>
>> dbms_output.put_line(i);
>> END;
>> /
>>
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

> 
> Thank you, but the problem is to pass an array from crystal report to
> oracle

That is not a problem. That is easily done. Contact support at Business Objects if you need help with your tool.

I stated in my first response that you MUST use IN OUT parameters. Did you?

-- 
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 Fri Aug 10 2007 - 10:39:30 CDT