Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CLOB / VARCHAR2
A copy of this was sent to Mattias Malmgren <a2matmal_at_ulmo.stud.slu.se>
(if that email address didn't require changing)
On Wed, 10 Jun 1998 14:35:08 +0200, you wrote:
>In Oracle 8 this works fine
>
> x VARCHAR2(10) := 'ABC';
>
>but not this
>
> y CLOB :='abc';
>
>why ?
>
>How is a value assigned to a CLOB?
>
> / Mattias
In Oracle8.0, lobs only live in the database -- they do not live in memory.
You have to insert a row into a table with an empty clob and then you would use the dbms_lob package to read/write it.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Jun 10 1998 - 18:46:24 CDT