terima kasih pak bowo.. dua duanya udah saya coba dan berhasil semua..:) thanks ~boy~
----- Original Message ----- From: "Yulius Wibowo" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, December 13, 2005 3:02 PM Subject: [indo-oracle] Re: insert image di form > 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 >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > > > > > > > > > -- > -----------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 --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/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/
