| Troubles with Ordimage [message #75920] |
Mon, 11 March 2002 00:50  |
Marcos'
Messages: 1
Registered: March 2002
|
Junior Member |
|
|
Hello people!!
I'm having troubles with Oracle Intermedia. I want insert images into oracle database, but after I create the table, I initialize the fields and I create a directory with an way to the image I receive an error message. See the code and the message:
DECLARE
pict ORDSYS.ORDIMAGE;
ctx RAW(4000);
BEGIN
SELECT i.imgblob INTO pict from imagem i
WHERE i.imgcodigo = 81 FOR UPDATE;
pict.setSource('FILE','IMG','coração.jpeg');
pict.import(ctx);
UPDATE imagem i SET i.imgblob = pict WHERE i.imgcodigo = 81;
END;
DECLARE
*
ERRO na linha 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORDSYS.ORDSOURCE", line 181
ORA-22288: file or LOB operation FILEOPEN failed
O sistema não pode localizar o arquivo especificado.
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 485
ORA-06512: at "ORDSYS.ORDIMAGE", line 209
ORA-06512: at line 8
Please if anybody can help me I will stay very happy.
thank´s
|
|
|
|
| Re: Troubles with Ordimage [message #75921 is a reply to message #75920] |
Mon, 11 March 2002 01:28  |
Ravi Vide
Messages: 4
Registered: March 2002
|
Junior Member |
|
|
|
The code is looking beautiful. So, the problem can be with the path only. There is chance that, when u created the directory object ,u may specified the wrong path or the folder or file are not existing. When u r uploading image, using file uploading the directory should be server's local directory or some shared directory which can be accessable by the server.
|
|
|
|
|
|
| Re: Troubles with Ordimage [message #76004 is a reply to message #76001] |
Mon, 09 December 2002 23:38 |
Ravi Vide
Messages: 4
Registered: March 2002
|
Junior Member |
|
|
|
u r right ronan. But small modification. The directory must be on the same computer or on any computer but should be accessable by this computer.(i.e, Shared folder)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
