UPDATE bilde_test SET photov = Image where photo_id = 4;
When I try to execute the procedure, I get the following error report. (It's in Norwegian, so I've tried to translate the norwegian text) :
ERROR on linj 1:
ORA-06510: PL/SQL: untreated useddefined exception
ORA-06512: at "ORDSYS.ORDSOURCE", line 266
ORA-22288: file- or LOB-operation FILEOPEN failed
The data is invalid.
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 701
ORA-06512: at "ORDSYS.ORDIMAGE", line 223
ORA-06512: at line 12
I've tried several other procedures, with the same result. I've granted read access to the directory. Seems like the trouble occurs around the "import" statement.
I'm new to Oracle, so I'd very much appreciate all your help