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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yulius Wibowo Sent: 20 Maret 2007 7:12 To: [email protected] 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> [EMAIL PROTECTED] > > Website: http://indo- <http://indo-oracle.blogspot.com> oracle.blogspot.com > > Mirror: http://indooracle. <http://indooracle.wordpress.com> wordpress.com > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo- <http://indo-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.yahoo.com/promo-generic-14795097> yahoo.com/promo-generic-14795097 > [Non-text portions of this message have been removed]
