Convertvarchar2 to clob

[kv444]

Hi,

Could some one please tell me how i can convert VARCH2 to clob datatype in plsql.



Thanks

 

[SantaMufasa]

I believe what you want is to simply assign the CLOB from the Varchar2:

declare
    My_VarChar varchar2(20) := 'Hello KV444';
    My_Clob    CLOB;
begin
    dbms_output.put_line(my_varchar||': This is from the Varchar2.');
    My_Clob := My_varchar||': This shows Varchar2-to-CLOB conversion.';
    dbms_output.put_line(My_Clob);
end;
/

Let us know if this is what you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[SantaMufasa]

Duh...it would be helpful if I posted the results of the above code, huh.:

Hello KV444: This is from the Varchar2.
Hello KV444: This shows Varchar2-to-CLOB conversion.

PL/SQL procedure successfully completed.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.