CLOB variable

Hello,
How can i use a varible which has varchar2 datatype. but the contains size of this variable is over than 23767. I want to use Clob datatype but how can ujse it.

Exple:
v_where varchar2(32000)

select * from tt where tt.idy IN (v_where).

thanks Received on Wed Jul 23 2003 - 08:47:57 CDT