[Pl/Sql]lob operation FILEOPEN failed
Salut,
J'ai besoin d'inserer un blob(image) dans un champ, j'ai donc suivi le modele decrit ds le tuto de helyos:"Les Larges Objects (LOB) sous Oracle 9i"
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
CREATE OR REPLACE PACKAGE sql_blob IS
PROCEDURE add_blob(p_id NUMBER, p_name VARCHAR2);
END sql_blob;
/
CREATE OR REPLACE PACKAGE BODY sql_blob IS
PROCEDURE add_blob(p_id NUMBER, p_name VARCHAR2) IS
v_blob BLOB;
v_bfile BFILE;
BEGIN
INSERT INTO t_blob
VALUES
(p_id, empty_blob())
RETURNING image INTO v_blob;
v_bfile := bfilename(directory => 'BLOBDIR', filename => p_name);
dbms_lob.fileopen(v_bfile);
dbms_lob.loadfromfile(v_blob, v_bfile, dbms_lob.getlength(v_bfile));
dbms_lob.fileclose(v_bfile);
END;
END sql_blob;
/ |
tout s'execute normalement (jai donné au user le droit de creer une session par:grant create session to le_user;
Au lancement de la procedure: exec sql_blob.add_blob(1,'image.png');
j'ai l'erreur suivante:
Code:
1
2
3
4
5
6
7
|
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
The system cannot find the file specified.
ORA-06512: at "SYS.DBMS_LOB", line 504
ORA-06512: at "SYS.SQL_BLOB", line 15
ORA-06512: at line 1 |
Qlq un aurait il une solution?
