RE: Using CLOB

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Mon, 17 Sep 2001 12:20:32 -0700
Message-ID: <F001.00390BA8.20010917114020@fatcity.com>

<SPAN

class=031533718-17092001>Yuval,
<SPAN

class=031533718-17092001> 
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.
<SPAN

class=031533718-17092001> 
<SPAN

class=031533718-17092001>Jack

--------------------------------Jack C. 

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com(512)327-9068

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Yuval ArnonSent:   Monday, September 17, 2001 1:40 PMTo: Multiple recipients of list   ORACLE-LSubject: 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 <FONT
  face=Arial size=2>  4  c := 'This is a test'; <FONT   face=Arial size=2>  5* END; SQL>
  / c := 'This is a test'; <FONT
  face=Arial size=2>     * <FONT face=Arial   size=2>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 - 14:20:32 CDT