Re: Stored procedure parameter

On Aug 10, 9:54 am, "sfauchi..._at_gmail.com" <sfauchi..._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

What happened when you tried my suggestion? Given that nobody here has Crystal reports, what does the call to the procedure look like?

btw you need TABLE() or MEMBER OF depending on your Oracle version, which I think you forgot to mention. Explicit casting is not generally needed in versions above 8i. Received on Fri Aug 10 2007 - 07:16:15 CDT