Re: end-of-file on communication channel

From: KevinS <>
Date: Tue, 5 Aug 2008 04:42:05 -0700 (PDT)
Message-ID: <>

Thanks gazzag,

One of the DBA's came up witha work araound of altering the sql as follows.

SELECT mp.ID AS ID,           mp.a2 AS a2,
       mp.a3 AS a3,
       SUM(nvl(ocp.b1,0)) b1, SUM(nvl(ocp.b2,0)) b2,
       SUM(nvl(ocp.b3,0)) b3, SUM(nvl(ocp.b4,0)) b4,
       SUM(nvl(ocp.b5,0)) b5, SUM(nvl(ocp.b6,0)) b6,
       SUM(nvl(ocp.b7,0)) b7, SUM(nvl(ocp.b8,0)) b8,
       SUM(nvl(ocp.b9,0)) b9, SUM(nvl(ocp.b10,0)) b10,
       MAX(cp.a4) a4
FROM   alpha mp,  alpha cp,
       beta pt,   gamma psp,
       delta ocp
WHERE mp.ive = 1
AND   mp.ate = 0

AND mp.ram = 0
AND mp.ID = pt.prpid
AND psp.prtaskid =
AND   cp.ID = psp.prefpid
AND   cp.ive = 1
AND   cp.ID = ocp.ID
AND   ocp.code IN (SELECT code
                   FROM cl
                   WHERE cl.parent_lookup_code = 'A'
                   AND cl.ive = 1)

AND = 5010000

It seems to have done the trick so as it's now logged here, perhaps it may help someone else.

Anyone got an explanation for this? Received on Tue Aug 05 2008 - 06:42:05 CDT

Original text of this message