We have had some problems with the net during the holidays and I haven´t received some emails.
If somebody wrote any message related with this this doubt, I would be very grateful if she/he send it again to me,
a lot of thanks,
Beatriz Martínez Jiménez wrote:
Hello list,
I get this error, working with the dbms_lob package.
(NT4, oracle 8.1.7)
This is the sequence of steps I have followed:CREATE OR REPLACE DIRECTORY DIRECT_IMAGEN AS 'E:\DIRECT_IMAGEN';ORA-21560: argument 3 null, not valid or out of range.
CREATE OR REPLACE PROCEDURE insert_image
AS
file BFILE;
lob BLOB;
BEGIN
insert into t_image (id, image_lob) VALUES (5, EMPTY_BLOB())
return image_lob into lob;
file:=bfilename('DIRECT_IMAGEN','foto1.gif');
dbms_lob.fileopen(file, dbms_lob.file_readonly);
dbms_output.put_line(dbms_lob.getlength(lob));
dbms_lob.loadfromfile(lob, file, dbms_lob.getlength(lob));
dbms_lob.fileclose(file);
commit;exec insert_image;
The third argument is the length of the image, which is equal to 0.
The directory is in the local machine, as well as the image, and this machine is the database server.
The user has read privileges on this directory,
What am I doing wrong? A lot of thanks.
begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard