Home » Server Options » Text & interMedia » Troubles with Ordimage
Troubles with Ordimage [message #75920] Mon, 11 March 2002 00:50 Go to next message
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 Go to previous messageGo to next message
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 #76001 is a reply to message #75920] Tue, 26 November 2002 10:53 Go to previous messageGo to next message
Ronan
Messages: 1
Registered: November 2002
Junior Member
The directory that your 'IMG' points
to MUST be on the same computer
that the instance of Oracle is running on !!!!
Re: Troubles with Ordimage [message #76004 is a reply to message #76001] Mon, 09 December 2002 23:38 Go to previous message
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)
Previous Topic: Urgent, can't figure out what is wrong with InterMedia
Next Topic: Re: DBMS_JOB
Goto Forum:
  


Current Time: Fri Mar 29 01:41:16 CDT 2024