Re: Using SQL IN predicate in PL/SQL
From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 17:25:02 GMT
Message-ID: <3C7E67F2.5D4DF647_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 17:25:02 GMT
Message-ID: <3C7E67F2.5D4DF647_at_ci.seattle.wa.us>
I don't believe you can make it function in the way you are trying. Likely you will need to break up v_Pool and then concatenate it together again.
Daniel Morgan
R Chin wrote:
> In PL/SQL I have constructed a variable (called v_Pool) with the value
> ('ABC','DEF','GHI') to be used in the where clause of dynamic sql
>
> The following code does not work...please help
>
> if v_test IN v_Pool then
> ........;
> end if;
>
> Thanks
>
> Robert
Received on Thu Feb 28 2002 - 18:25:02 CET