Re: Passing an "in" string to a Stored Procedure

Rod Corderey wrote:

> What you could do would be to use DBMS_SQL to execute you're statement
> dynamically, then you could build in the passed in-list.

A way to do it without using DBMS_SQL is using a PL/SQL table as input for the stored procedureand then loop through it, style ...

    i number;
...

    i:=0;
    loop

      i:=i+1;
     exit when not pl-sql-table.exists(i);
     select * from thing
       where number_id = pl-sql-table(i);

   end loop;
...

r u d i
(remove anti-spam measure from reply-address) Received on Thu Apr 30 1998 - 00:00:00 CDT