Read a compress files from PL/SQL

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Wed, 24 Jan 2001 16:02:51 +0100
Message-Id: <10751.127361@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C08616.EEA5B0D4

Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi gurus,=20

We work with huge compress files of 2-5 gigas. All these programs are made with Pro*Fortran ( I don't know why, but it is !!!!!). We want to rewrite these programs with PL/SQL. =20

My question is : Is it possible to read a compress file from PL/SQL ?=20

We use SQLLoader with a named pipe : example=20

rm -f $Nodtmp=20
/usr/sbin/mknod $Nodtmp p=20

(=20

zcat $SOURCE/cod_encrevol_metr.$Date_ssaamm.Z \=20

     $SOURCE/cod_encrevol_pdom.$Date_ssaamm.Z \=20
     | grep -v '^.\{41\}UCB'  > $Nodtmp=20

) &=20

sleep 20=20

CTL=3D/data/stat/d1/Donmens/Alim/load_T_ccb_cod_cp.ctl=20
LOG=3D$TRACE/load_T_ccb_cod_cp.log=20
BAD=3D$TRACE/load_T_ccb_cod_cp.bad=20

=20
sqlldr userid=3D$User_oracle control=3D$CTL log=3D$LOG bad=3D$BAD = data=3D$Nodtmp=20

Can we do the same with a PL/SQL procedure ?=20

TIA=20

-----------------=20

Luc Demanche=20
CETELEM=20
T=E9l.: 01-46-39-14-49=20
Fax : 01-46-39-59-88=20

------_=_NextPart_001_01C08616.EEA5B0D4

Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<TITLE>Read a compress files from PL/SQL</TITLE>
</HEAD>
<BODY>

Hi gurus,

We work with huge compress files of = 2-5 gigas.  All these programs are made with Pro*Fortran ( I don't = know why, but it is !!!!!).  We want to rewrite these programs = with PL/SQL.

My question is :  Is it possible = to read a compress file from PL/SQL ?

We use SQLLoader with a named pipe : = example

rm -f $Nodtmp /usr/sbin/mknod $Nodtmp = p

(

zcat = $SOURCE/cod_encrevol_metr.$Date_ssaamm.Z \      = $SOURCE/cod_encrevol_pdom.$Date_ssaamm.Z \      | grep = -v '^.\{41\}UCB'  > $Nodtmp

) &

sleep 20 CTL=3D/data/stat/d1/Donmens/Alim/load_T_ccb_cod_cp.ctl LOG=3D$TRACE/load_T_ccb_cod_cp.log BAD=3D$TRACE/load_T_ccb_cod_cp.bad   sqlldr userid=3D$User_oracle = control=3D$CTL log=3D$LOG bad=3D$BAD data=3D$Nodtmp

Can we do the same with a PL/SQL = procedure ?

<P><FONT SIZE=3D2 FACE=3D"Courier New">TIA</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">-----------------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Luc Demanche</FONT>
<BR><B><I><FONT FACE=3D"Arial">CETELEM</FONT></I></B>

T=E9l.: 01-46-39-14-49 Fax : 01-46-39-59-88 Received on Wed Jan 24 2001 - 09:02:51 CST