Re: PL/SQL Using Variable IN Clause

Hi Robert

What you try to do is impossible... i'm sorry, but there exists a solution use the DBMS_SQL Package and parse your SQL-Statemment dynamically.

Greetings
Charly Schmi

Robert Fernandes schrieb in Nachricht <34746C85.86E636A6_at_llnl.gov>...
>I have spent much too much time trying to figure this one out on my own
>and it's now time to ask for some help...
>
>I am trying to create a procedure with the following:
>
>
>PROCEDURE PROC(LIST_STRING IN VARCHAR2)
> RESULT NUMBER;
>IS
>BEGIN
>
> <DO SOME STUFF>
>
> SELECT COUNT(*) INTO RESULT
> FROM <TABLE>
> WHERE <COL_A> = 'VALUE'
> AND <COL_B> IN(LIST_STRING); <-- Help Here!
>
> IF RESULT >= 1 THEN
Received on Thu Nov 20 1997 - 00:00:00 CST