Conerting VARCHAR2 to CLOB

From: rob burton <robburton_at_totalise.co.uk>
Date: 16 Nov 2001 02:50:55 -0800
Message-ID: <feb77408.0111160250.66fbb9cd@posting.google.com>

I have a problem, using Oracle 8.1.6 .

I have a varchar2(32767) variable in a PL/SQL procedure that passes the result back to the calling application in a REF CURSOR. Previously the string was a varchar2(4000) and could happily be passed back. In order to pass the resulting string back the Cursor variable has been changed to a CLOB.

The problem is I can't convert the varchar2 string to a clob to pass back. How can I do this.

The existing call fails because of the attempted conversion..

open 	rc_clob_out for
	select 	varchar2_variable as clob_value,
	other_var1 as var1
        from dual;

Any help appreciated

Thanks

Rob.. Received on Fri Nov 16 2001 - 04:50:55 CST