Betul, dengan menggunakan procedure READ_IMAGE_FILE, anda bisa memasukkan file image (dari file system dengan format BMP, GIF, JPG, ...) ke dalam database. Tapi, * file image yg ada di client (kalau masih pakai 6i) * file image yg ada di server (Form Server, kalau pakai 9i/10G atau 6i yg dideploy di web)
Contoh: Form 6i, Client-Server Mode pada trigger W-B-P sebuah tombol declare filename VARCHAR2(100) := 'D:\myimage\test.jpg'; begin READ_IMAGE_FILE(filename, 'JPG', 'BLOCK1.IMAGE1'); -- catatan, ada sebuah item: IMAGE1 pada block : BLOCK1 -- dengan item type : IMAGE COMMIT; end; Bowo --- In [email protected], "boy" <[EMAIL PROTECTED]> wrote: > > makasih pak bowo atas responnya... > tapi bukan itu yang saya maksud... > maksud saya adalah cara menyimpan file image ke dalam tabel database lewat > oracle form.. > maaf kalo saya salah menjelaskan :) > > ini adalah potongan script saya.. > > --create table foto_kar_mf ( nik varchar2(11) primary key, Foto blob) > --create or replace directory my_files as '/export/home/tkyte/public_html'; > > declare > l_blob blob; > l_bfile bfile; > begin > insert into foto_kar_mf values ( '940130', empty_blob() ) > returning foto into l_blob; > l_bfile := bfilename( my_files, '940130.bmp' ); > dbms_lob.fileopen( l_bfile ); > dbms_lob.loadfromfile( l_blob, l_bfile, > dbms_lob.getlength( l_bfile ) ); > dbms_lob.fileclose( l_bfile ); > end; > > saat script itu saya jalankan lewat SQL plus berhasil, kemudian saya ingin > jalankan script tsb lewat oracle form..saya lewatkan di item button ( > triggernya WHEN-BUTTON-PRESSED ), keluar error : > > Implementation Restriction:'DBMS_LOB.FILE_READONLY':Cannot directly access > remote package variable or cursor.. > > itu yang bikin saya bingung...:( > > thanks... > ~boy~ > > > ----- Original Message ----- > From: "Yulius Wibowo" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, December 13, 2005 1:51 PM > Subject: [indo-oracle] Re: insert image di form > > > > Saya kasih hint-nya saja ya ?! > > > > "READ_IMAGE_FILE" > > > > Bowo > > > > > > --- In [email protected], "boy" <[EMAIL PROTECTED]> wrote: > >> > >> Salam, > >> > >> Rekan2 mo nanya nich.. > >> > >> gimana caranya insert image lewat form..? saya udah coba lewat > > sqlpus sukses, giliran saya pindahin ke lewat form kok gagal.. > >> pesen errornya :' > >> Implementation Restriction:'DBMS_LOB.FILE_READONLY':Cannot directly > > access remote package variable or cursor.. > >> > >> pless help me.. > >> > >> thanks... > >> > >> [Non-text portions of this message have been removed] > >> > > > > > > > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.lizt.org (NEW) > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
