Tambahan, kalau anda memang mau menggunakan script yg sudah anda buat (dan berhasil kalau dijalankan di SQL*Plus), saran saya : 1. Convert menjadi stored procedure (package) 2. Lalu call procedure/package tsb dari form dengan memasukkan nilai melalui parameter/argument-nya 3. File yg dibaca adalah file di database server (bukan di client)
Bowo --- In [email protected], "Yulius Wibowo" <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/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/
