Using CLOB

From: Yuval Arnon <Yuval.Arnon_at_wwfent.com>
Date: Mon, 17 Sep 2001 10:43:28 -0700
Message-ID: <F001.003909D8.20010917104023@fatcity.com>

Hi,
How can you assign a text to a CLOB column defined in the DECLARE section of PL/SQL.I am getting an error on wrong type.

i.e..

SQL> l
  1  declare
  2  c clob ;
  3  BEGIN
  4  c := 'This is a test';
  5* END;

SQL> /
c := 'This is a test';
     *
ERROR at line 4:

ORA-06550: line 4, column 6:
PLS-00382: expression is of wrong type
ORA-06550: line 4, column 1:

PL/SQL: Statement ignored

Yuval Arnon Received on Mon Sep 17 2001 - 12:43:28 CDT