Re: CLOB variable

From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 28 Jul 2003 18:09:55 GMT
Message-ID: <TFdVa.12100$j%4.492008@twister.socal.rr.com>

black wrote:
<snip>
> Exple:
> v_where varchar2(32000)
>
> select * from tt where tt.idy IN (v_where).
>
> thanks

This example is probably not going to do what you want. I suspect you are going to put a list of values in that v_where variable. You can't use an IN clause like that. Take a look at this thread from asktom to see a working solution for this ...

http://asktom.oracle.com/pls/ask/f?p=4950:8:7276155014652171739::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:210612357425,

Richard Received on Mon Jul 28 2003 - 13:09:55 CDT