CREATE TABLE table_a(ID varchar(2), NAMA varchar2(20), FOTO blob);
CREATE DIRECTORY my_photo_dir AS 'C:\photo';
DECLARE
v_file BFILE;
v_foto BLOB;
v_fileSize NUMBER;
BEGIN
insert into table_a(id, nama, foto)
values('A1', 'JOKO', EMPTY_BLOB())
RETURNING foto INTO v_foto;
v_file := bfilename('MY_PHOTO_DIR', 'JOKO.JPG');
dbms_lob.fileopen(v_file, dbms_lob.file_readonly);
v_fileSize := dbms_lob.getlength(v_file);
dbms_lob.loadfromfile(v_foto, v_file, v_fileSize);
COMMIT;
END;
/
CMIIW,
Bowo
--- In [email protected], okie lucu <[EMAIL PROTECTED]> wrote:
>
> temans...
> ada yg sudah pernah insert BLOB ke database?
>
> saya punya tabel, yg isi nya :
> TABEL_A
> ID = varchar(2)
> NAMA = varchar (20)
> FOTO = blob
>
> saya masih ada masalah untuk meng-isikan foto tersebut.
> barangkali ada yang bisa membantu...
>
> terima kasih
> mohon maaf apabila topik ini sudah ada sebelumnya...
> maklum, NEW MEMBER
>
>
> ---------------------------------
> New Yahoo! Mail is the ultimate force in competitive emailing.
Find out more at the Yahoo! Mail Championships. Plus: play games and
win prizes.
>
> [Non-text portions of this message have been removed]
>
