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 [email protected], "Yulius Wibowo"
<[EMAIL PROTECTED]> wrote:
>
> Pakai UTL_COMPRESS
>
> Bowo
>
> --- In [email protected], 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]
> >
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.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/
