RE: Using CLOB

[Jack C. Applewhite]

Title: Using CLOB

Yuval,

 

AFAIK, you can't do it by simply assigning values.  You've got to use the procedures and functions supplied package DBMS_LOB to create and manipulate "temporary" LOBs.

 

Jack

--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Yuval Arnon
Sent: Monday, September 17, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Using CLOB

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