Message-Id: <10617.116713@fatcity.com> From: azhar@mathtech-pk.com Date: Tue, 12 Sep 2000 12:02:14 GMT Subject: Inserting BLOB from a Client Hi all, i want to insert and retreive blob from server using developer2000 and oracle8i, i have used the method given below to insert blob into the database. but it only works when the directory object is given path on server . suppose i give path as create or replace directory my_files as '\\MACHINE1\DIR' , THEN IT DOES NOT WORK . Is it possible to do it or any other way out . The way which i figured out is to copy file using HOST command in developer 2000 in a server directory and then insert file into server using the procedure gieven below. But it is not practical , how can i insert the file just from client running developer2000 without copying to server? i dont want to copy file to server first and then insert into database. Kindly help out Regards, create table demo ( id int primary key, theBlob blob ) / create or replace directory my_files as 'c:\temp'; create or replace procedure load_a_file( p_file in varchar2 ) as l_blob blob; l_bfile bfile; begin insert into demo values ( 1, empty_blob() ) returning theBlob into l_blob; l_bfile := bfilename( 'MY_FILES', p_file ); dbms_lob.fileopen( l_bfile ); dbms_lob.loadfromfile( l_blob, l_bfile, dbms_lob.getlength( l_bfile ) ); dbms_lob.fileclose( l_bfile ); end; / Azhar Siddiq, Mathtech, Pakistan #18, F-8/3 Main Margalla Road, Islamabad, Pakistan. Tel: 92 51 111101101 Fax: 92 51 255989 e-mail: azhar@mathtech-pk.com