Re: sp and data convertion

From: Alexander Medvedev <a.medvedev_at_globalone.ru>
Date: Fri, 15 Dec 2000 11:50:16 +0300
Message-ID: <3A39DB48.BC98985B@globalone.ru>

"Lee J." wrote:

> 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.

Use dbms_sql package or Native (in last Oracle versions) - they both allows you dynamic select statement creation and execution. Remember that dbms_sql has its own tools to fetch rows and get values from query.

Regards, Alexander Medvedev Received on Fri Dec 15 2000 - 02:50:16 CST