Re: Stored procedure parameter

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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org