You could use dynamic sql. Just construct the query and concat the myparam
in there so the result would be:
'select .... from ... where id in ('||myparam||')'
see the dbms_sql package or if you are using Oracle 8i the execute immediate
I believe.
"Lee J." <ljeznach_at_csi.com> wrote in message
news:G1c_5.81895$_5.17624360_at_news4.rdc1.on.home.com...
> Hello,
> I have one procedure
>
> PROCEDURE SP_TEST(RECORD_SET OUT CURSOR_TYPE, MYPARAM VARCHAR2)
> AS ...
> MYPARAM can hold as many characters as VARCHAR2 data type allows in the
> format '1,2,3,22,500'
> I would like to use it in my query where e.g. SELECT * FROM ... WHERE id
IN
> (MYPARAM)
> Of course, it will not work because my parameter is of VARCAR2 type.
> As fare, as I know there is no function that would convert my parameter to
> anything that would work with my query.
> If any of you guys has any idea how to make it working then I v.
appreciate
> your help.
> Thanks.
>
>
>
Received on Sun Dec 17 2000 - 13:52:05 CST
