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





Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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