Re: end-of-file on communication channel

On 5 Aug, 10:43, KevinS <Sear..._at_googlemail.com> wrote:
> Hello,
>
> The query below (names changed so I don't give away too many company
> secrets!!) works fine unless you uncomment the line 'AND mp.id =
> 5010000' when an 'end-of-file on communication channel' error occurs.
>
> 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 = 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;
>
> Searching on google would suggest it's an issue with the database
> rather than the sql but the DBA's are scratching their heads.
>
> Any suggestions?
>
> Thanks

What version of Oracle and, for that matter, operating system?

-g Received on Tue Aug 05 2008 - 05:12:17 CDT