ORA-22288: file operation LOADFROMFILE when trying to insert a blob

From: Erik Bengtsson <erik_at_bengtsson.net>
Date: Fri, 20 Aug 1999 09:31:53 +0200
Message-ID: <7pj09v$f3p$1@mafalda.lule.frontec.se>

Using T. Kytes procedure:

PROCEDURE las_in (

   iv_namn      IN   VARCHAR2,
   iv_mejl      IN   VARCHAR2,
   iv_telefon   IN   VARCHAR2 DEFAULT NULL,
   iv_foto      IN   VARCHAR2

)
IS

   lobd BLOB;

   fils    BFILE         := BFILENAME ('MY_FILES', iv_foto);
   amt     INTEGER;

   w_var VARCHAR2(200);
BEGIN
   dbms_lob.fileopen (fils, dbms_lob.file_readonly);    amt := dbms_lob.getlength (fils);
   INSERT INTO konsulter (namn, mejl, telefon, foto)

        VALUES (iv_namn, iv_mejl, iv_telefon, EMPTY_BLOB ())
     RETURNING foto INTO lobd;

   dbms_lob.loadfromfile (lobd, fils, amt);    COMMIT;
   dbms_lob.fileclose (fils);
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      NULL;
   WHEN OTHERS
   THEN

      w_var := SQLERRM;
      INSERT INTO apa
           VALUES ('Others: ' || w_var);
      COMMIT;

END las_in;

I have created the directory and checked all the file permissions and I am sure that is not the problem.

Thanks

/Erik
--

---

Erik Billerby
Frontec Konsulter Göteborg
Tel: 031-707 12 45

---

Received on Fri Aug 20 1999 - 02:31:53 CDT