Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IN LIST in PL/SQL
"James A. Williams" <jwilliam_at_aglresources.com> wrote in message
news:5003a2b9.0401191648.2c0facfd_at_posting.google.com...
> I have some anonymous PL/SQL in the below I am testing for a routine
> eventually to be called from C# application. I am trying to build an
> IN list in a variable as the below shows and it is not taking it.
>
> I take a string '04,06,08' and try to get it to work as select * from
> t_table where b IN (V_VARIABLE);
>
> It only works when I hard code the variables. My next step is to look
> at the 9i pipeline functions if the below or something close will not
> work.
Look into user-defined operators, with very little work you can create an operator that will take an array of strings and test for set membership. Received on Mon Jan 19 2004 - 21:01:07 CST