-
Hi,
I have created a table like this:
CREATE TABLE photo (
phot_id number(100)
image blob);
I want to insert values ! But how ?
For example, I want to insert an image named nic.jpg which is in the directory C:\Oracle .... What must I do to insert the value in the table ?
Thanks
Nic
-
blobs can be manipulated using pl/sql. i don't remember the exact syntaxes and commands for this. you can refer the documentations for this.
Anil
anil_tj@yahoo.com
-
hi
u have to first insert data like this...
Insert into <>
Values(1,empty_blob());
use empty_blob() function for blob column...
and then write a procedure to insert data...
I am sending u my procedure Please manipulate it accordingly....
CRETE OR REPLACE PROCEDURE V_LOAD AS
ac Blob;
amount integer;
a_file bfile := BFILENAME('TEST', 'ITS1.GIF');
F_LEN NUMBER(6);
begin
update <> set BLOB_FILE = empty_Blob()
where BLOB_ID = 1
returning BLOB_FILE into ac;
DBMS_LOB.FILEOPEN(a_file, dbms_lob.file_readonly);
F_LEN:=DBMS_LOB.GETLENGTH(A_FILE);
amount := F_LEN ;
DBMS_LOB.LOADFROMFILE(ac, a_file, amount);
DBMS_OUTPUT.PUT_LINE(F_LEN);
DBMS_LOB.FILECLOSE(a_file);
commit;
update <>set BLOB_FILE = ac
where BLOB_ID = 1;
end;
this table has got only two fields....blob_file and blob_id...
then u can access this data with the help of query...
regards
Amit
-
There is a perl script you can use, which will do it.. requires to to install DBD and DBI (oracle driver) to use it... then it's fairly easy to use.
I've seen it on several personal web sites... sorry I don't have it myself, I seem to have lost my copy.
usually the name is blob.pl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Click Here to Expand Forum to Full Width
|
|