Re: WHERE IN (v_SomeVariable)

From: Bruno Cossi <Bruno.Cossi_at_Consultant.com>
Date: Sat, 18 May 2002 23:05:46 -0400
Message-ID: <dEEF8.23190$oF2.3044832@news20.bellglobal.com>

Are you sure the list does not contain a NULL value? That could be the problem.

Bruno

"Tom Dyess" <nospam_at_nospam.spm> wrote in message news:ac100v$nje$1_at_news.gate.net...
> Hi all,
>
> I'm helping someone with a PL/SQL script and I'm a little rusty. I'm
> trying to create a dynamic cursor that uses the WHERE IN () clause with a
> variable which is a varchar2 that is a comma delimited list of single
quoted
> strings - ie
>
> '00002020','00004808','00002962'
>
> And the SQL/Cursor looks like this
>
> INSERT INTO SOMETABLE
> SELECT key_date, fdate
> FROM DATES
> WHERE dat.key_date IN (v_SomeVar);
>
> but this isn't returning any results. What is the best way to create a
> dynamic SQL statement using the WHILE clause with an IN modifier?
>
> Thanks,
> Tom
>
>
Received on Sat May 18 2002 - 22:05:46 CDT