|Inserting BLOB - Unable to Locate file on Server [message #309112]
||Wed, 26 March 2008 08:05
Registered: March 2005
I have following table which uses BLOB field.
CREATE TABLE SIGNS
LSEQ NUMBER(12) NOT NULL,
LOB (STRSIGNATURE) STORE AS
( TABLESPACE TBS01
ENABLE STORAGE IN ROW
I loaded a record into the table as following
insert into SIGNS values ( 3, empty_blob() )
returning SIGNATURE into l_blob;
l_bfile := bfilename( 'DIR9', 'mast2.bmp' );
dbms_lob.fileopen( l_bfile );
dbms_lob.loadfromfile( l_blob, l_bfile,
dbms_lob.getlength( l_bfile ) );
dbms_lob.fileclose( l_bfile );
it went fine and the file mast2.bmp as at /u02/DB01/test9
Insert into SIGNS values(5);
Then I carried following actions from TOAD from client.
edit SIGNS where lseq=5;
Right clicked the record displayed
3) Clicked "Memo Editor"
4) Clicked "Load File" icon
5) Selected a file 'c:\test.bmp' from local drive.
6) commited the transaction.
Now I was able to view the Image from application or even tools like SQL Developer, PL/SQL developer
however when i searched 'test.bmp' on the database server, I was unable to find it out.
Even if I 'Load File' from local machine using SQL Developer or PL/SQL Developer, I can see the image from application but just can't locate the file on server.
Kindly suggest what could be happening with the files and how to locate the files on the server?
Thanks and Regards,