Message-Id: <10751.127361@fatcity.com> From: "DEMANCHE Luc (Cetelem)" Date: Wed, 24 Jan 2001 16:02:51 +0100 Subject: Read a compress files from PL/SQL 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 Read a compress files from PL/SQL

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 ?

TIA


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