Nerus nih teman-teman, lalu bagaimana kalau parameter , '<<ALL FILES>>' ingin kita ganti dengan khusus Text File saja, bagaimana kalimatnya?
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Asep Inbisco IT Sent: 20 Maret 2007 8:35 To: [email protected] Subject: RE: [indo-oracle] Re: Output PL-SQL ke zip Wuiih.......hebat ....command tersebut sudah saya execute dan berhasil melakukan zip file dari file sebesar 1.260 KB jadi hanya sekecil 57 KB saja. Thank's Mas Bowo, Mas Hernowo, Thank's teman-teman.... _____ From: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com [mailto:indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com] On Behalf Of Yulius Wibowo Sent: 20 Maret 2007 7:12 To: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com Subject: [indo-oracle] Re: Output PL-SQL ke zip Yoi,... Sorry, kurang Jalankan perintah tsb sbg user SYS Asumsinya, yg melakukan zipping adalah SCOTT ... SQL> EXEC DBMS_JAVA.grant_permission ('SCOTT', 'java.io.FilePermission', '<<ALL FILES>>', 'read ,write, execute, delete'); CMIIW, Bowo --- In indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com, Hernowo <[EMAIL PROTECTED]> wrote: > > Saya juga mencoba sudah mencoba solusi dari mas > bowo.Waktu itu saya pakai untuk nge-zip flat file. > > Mungkin yang perlu diperhatikan adalah grant java-nya. > Coba deh di grant dulu pake > dbms_java.grant_permission. > > CMIIW > > > --- Asep Inbisco IT <[EMAIL PROTECTED]> wrote: > > > Maaf teman-teman saya buka lagi arsip lama dari mas > > Bowo, mas Bowo saya > > sudah coba solusi dari mas Bowo dibawah ini, dan > > ketika dijalankan keluar > > pesan 'PL/SQL procedure successfully completed' , > > tapi kenapa hasilnya > > tidak ada? (Zip file tidak terbentuk). Apa saja yang > > harus saya perhatikan > > sebelum menjalankan procedure ini? Sebagai informasi > > saya punya text file > > yang akan saya compress di directory /u02/test.txt > > yang letaknya di database > > server yang menggunakan os RHEL ver 4 for OpenPower. > > > > Demikian problem saya,mohon pencerahan dari mas Bowo > > dan teman-teman. > > > > -----Original Message----- > > From: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com > > [mailto:indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com] On > > Behalf Of Yulius Wibowo > > Sent: 05 Juli 2006 10:24 > > To: indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com > > Subject: [indo-oracle] Re: Output PL-SQL ke zip > > > > UTL_COMPRESS hanya ada mulai database 10G. > > > > Alternatif lain, anda bisa membuat program > > menggunakan Java di dalam > > database. Berikut ini contoh program yg saya kutip > > dari sebuah > > source. > > > > > > CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED > > "UTLZip" AS > > import java.util.zip.*; > > import java.io.*; > > public class UTLZip > > { > > public static void compressFile(String infilename, > > String > > outfilename) > > { > > try > > { > > FileOutputStream fout = new > > FileOutputStream(outfilename); > > ZipOutputStream zout = new > > ZipOutputStream(fout); > > ZipEntry ze = new ZipEntry((new > > File(infilename)).getName()); > > try > > { > > FileInputStream fin = new > > FileInputStream(infilename); > > zout.putNextEntry(ze); > > copy(fin, zout); > > zout.closeEntry(); > > fin.close(); > > } > > catch (IOException ie) > > { > > System.out.println("IO Exception occurred: " + > > ie); > > } > > zout.close(); > > } > > catch(Exception e) > > { > > System.out.println("Exception occurred: " + e); > > } > > } > > > > public static void copy(InputStream in, > > OutputStream out) > > throws IOException > > { > > byte[] buffer = new byte[4096]; > > while (true) { > > int bytesRead = in.read(buffer); > > if (bytesRead == -1) break; > > out.write(buffer, 0, bytesRead); > > } > > } > > } > > / > > > > CREATE OR REPLACE PACKAGE UTLZip > > IS > > PROCEDURE compressFile (p_in_file IN VARCHAR2, > > p_out_file IN > > VARCHAR2) > > AS > > LANGUAGE JAVA > > NAME 'UTLZip.compressFile(java.lang.String, > > > > java.lang.String)'; > > END; > > / > > > > Contoh penggunaannya: > > > > SQL> exec UTLZip.compressFile > > ('/home/oracle/test.txt','/home/oracle/test.zip') > > > > > > Bowo > > > > > > --- In indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com, "Yulius Wibowo" > > <yulius_wibowo@> wrote: > > > > > > Pakai UTL_COMPRESS > > > > > > Bowo > > > > > > --- In indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com, Rahandra > > Pramono <RPramono@> > > > wrote: > > > > > > > > Dear all, > > > > > > > > > > > > > > > > Ada yang tau gak gimana melakukan kompresi > > langsung untuk output > > > dari > > > > pl-sql? > > > > > > > > Package yang dipakai apa ya? > > > > > > > > Atau Cuma ada satu cara dengan menggunakan > > kompresi dari system? > > > > > > > > > > > > > > > > Mohon pencerahannya ya > > > > > > > > > > > > > > > > Terima kasih > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > > > > > > > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: indo-oracle- <mailto:indo-oracle-unsubscribe%40yahoogroups.com> unsubscribe@ <mailto:unsubscribe%40yahoogroups.com> yahoogroups.com > > Website: http://indo- <http://indo-> <http://indo- <http://indo-oracle.blogspot.com> oracle.blogspot.com> oracle.blogspot.com > > Mirror: http://indooracle. <http://indooracle.> <http://indooracle. <http://indooracle.wordpress.com> wordpress.com> wordpress.com > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo- <http://indo-> <http://indo- <http://indo-thin.blogspot.com> thin.blogspot.com> thin.blogspot.com > > Yahoo! Groups Links > > > > > > > > > > > ------------------------------ > warm regards > ~hernk > > > > __________________________________________________________ _______________ > Now that's room service! Choose from over 150,000 hotels > in 45,000 destinations on Yahoo! Travel to find your fit. > http://farechase. <http://farechase.> <http://farechase. <http://farechase.yahoo.com/promo-generic-14795097> yahoo.com/promo-generic-14795097> yahoo.com/promo-generic-14795097 > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
