Re: CLOB variable

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 23 Jul 2003 22:16:00 +0200
Message-ID: <57rthvc1u1bp05kb2sb6dgn788o7ho6fg4@4ax.com>

On Wed, 23 Jul 2003 15:47:57 +0200, "black" <supergenial73_at_hotmail.com> wrote:

>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
>
>

Read up on LOBs and the dbms_lob package in the documentation

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 23 2003 - 15:16:00 CDT