Lecture d’un BLOB

set serveroutput on

spool monblob.txt

DECLARE
src_lob BLOB;
buffer RAW(32767);
amt BINARY_INTEGER := 32767;
pos INTEGER := 2147483647;
BEGIN
DBMS_OUTPUT.ENABLE(200000);

SELECT TAM_T_INFOS_SPEC INTO src_lob
FROM TAMPON;
LOOP
DBMS_OUTPUT.PUT_LINE(’Contenu du blob :’);
DBMS_LOB.READ(src_lob, amt, pos, buffer);

pos := pos + amt;
END LOOP;
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line(’Fin des donnees’);
END;

Laisser un commentaire


WordPress database error: [Table 'foubert.wp_ss_stats' doesn't exist]
INSERT INTO wp_ss_stats (remote_ip,country,language,domain,referer,resource,user_agent,platform,browser,version,dt) VALUES ('54.156.37.123','Indeterminable','empty','','','/wordpress/?p=40','CCBot/2.0 (http://commoncrawl.org/faq/)','Indeterminable','Crawler/Search Engine','Indeterminable',1502976322)