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: <sfauchille_at_gmail.com>
Date: Fri, 10 Aug 2007 08:54:27 -0000
Message-ID: <1186736067.525347.202900@i38g2000prf.googlegroups.com>


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 Received on Fri Aug 10 2007 - 03:54:27 CDT

Original text of this message

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