Re: end-of-file on communication channel

From: KevinS <SearleK_at_googlemail.com>
Date: Tue, 5 Aug 2008 04:42:05 -0700 (PDT)
Message-ID: <6f9bc931-9674-4d0e-99b2-638342fa1c51@s50g2000hsb.googlegroups.com>

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,
       ocp.code,
       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 = pt.pid

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 mp.id = 5010000
GROUP BY mp.ID,

       mp.unique_name,
       mp.NAME,
       ocp.code;

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