| Blob [message #372902] |
Fri, 16 March 2001 09:50  |
sunil_herb
Messages: 1
Registered: March 2001
|
Junior Member |
|
|
How to use BLOB and clob datatype in oracle
How to insert image?
|
|
|
|
| Re: Blob [message #372913 is a reply to message #372902] |
Sat, 17 March 2001 06:04  |
Jonas
Messages: 6
Registered: February 2001
|
Junior Member |
|
|
create table demo
( id int primary key,
theBlob blob
)
/
create or replace directory my_files as
'/export/home/pic_files';
declare
l_blob blob;
l_bfile bfile;
begin
insert into bild values ( 'SI-0001-08', empty_blob() )
returning theBlob into l_blob;
l_bfile := bfilename( 'MY_FILES', 'a76936.pdf' );
dbms_lob.fileopen( l_bfile );
dbms_lob.loadfromfile( l_blob, l_bfile,
dbms_lob.getlength( l_bfile ) );
dbms_lob.fileclose( l_bfile );
end;
/
/Jonas
|
|
|
|
| Re: ask another question about Blob storing [message #373205 is a reply to message #372902] |
Wed, 04 April 2001 03:10 |
danny xu
Messages: 1
Registered: April 2001
|
Junior Member |
|
|
hi,Sunil:
First,thanks for give a sample about blob-data type storing.
however,when using dbms_lob.loadfrom(),then system invoking " Directory or file not exist(ora2855)" error,but the directory and file actualy exists in server side (in windows NT 4.0 sp6 workstation operation system). Can you tell how to do with it.
Thanks a lot!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
