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
