1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| PROCEDURE importFile AS
v_obj ORDSYS.ORDDOC;
ctx RAW(64) :=NULL;
v_numero NUMBER(15);
BEGIN
select seq_ph_excel.nextval into v_numero from dual;
INSERT INTO ph_excel (numero, id, description, fichier)
VALUES (v_numero, 'null', 'null', ORDSYS.ORDDOC.init());
COMMIT;
SELECT fichier into v_obj FROM ph_excel where numero = v_numero FOR UPDATE;
v_obj.importFrom(ctx,'file','AM_TEST_DIR','photoPreFinalTest3.xls',FALSE);
UPDATE ph_excel SET fichier = v_obj WHERE numero = v_numero;
COMMIT;
END importFile; |
Partager