insertion into CLOB

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Mon, 12 Mar 2001 07:05:02 -0800
Message-ID: <F001.002C9811.20010312063521@fatcity.com>

Hi gurus,

Oracle 8.1.6.2
Solaris 2.6

I'm doing some tests with a CLOB field.  I created a stored procedure, which inserts text into a CLOB.

Here is my table :
create table relance (nom varchar2(50), texte CLOB);

Here is my code :
create or replace procedure insert_clob is
  buffer                    varchar2(32767);
  Lob_loc                   CLOB;
  Amount                    BINARY_INTEGER;
  Position                  INTEGER := 1;
 

begin

     buffer := 'test de clob, insertion dans le clob pour par le suite le lire';

     INSERT INTO relance(nom,texte) VALUES('luc',EMPTY_CLOB());
    
     SELECT LENGTH(buffer) INTO Amount
     FROM dual;
    
     SELECT texte INTO Lob_loc
     FROM relance
     WHERE nom = 'luc'
     FOR UPDATE;

     DBMS_LOB.WRITE (Lob_loc, Amount, Position, Buffer);

end insert_clob;

My procedure has been running for  30 minutes.  Is this normal ?

TIA

---

Luc Demanche
CETELEM
Tél.: 01-46-39-14-49
Fax : 01-46-39-59-88 Received on Mon Mar 12 2001 - 09:05:02 CST