Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to use DBMS_LOB.append() with a VARCHAR2 var. ?

How to use DBMS_LOB.append() with a VARCHAR2 var. ?

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Sun, 20 Aug 2000 17:36:01 +0200
Message-Id: <10595.115054@fatcity.com> 





Inside a PL/SQL procedure (for building a user datastore for Intermedia)
I need to append the value of VARCHAR2 field (inside a loop) to
a CLOB variable. DBMS_LOB.APPEND() only allows to append another BLOB|CLOB.
But how can I append just a stupid VARCHAR2 ?



Thanks


Andreas Jung
Received on Sun Aug 20 2000 - 10:36:01 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US