Accelerating sp, again!!!

From: Jorge Reyes <jorg_reyes_at_hotmail.com>
Date: Mon, 23 Feb 2009 15:20:36 -0800 (PST)
Message-ID: <63917dcb-b408-4822-adff-efbed5132324_at_v15g2000vbb.googlegroups.com>



Hi people, this is a continuation of the post titled "ACCELERATING STORED PROCEDURE" from the last week, am sorry for the inconvenience that might cause them to have to read the previous post but its a long history as you can see, so the last post was very useful and thanks you so much for your answers, but it was a final question about the last response from Charles who give me this query:

BEGIN SELECT A.CALL_SOURCE_REGID AS CLIENTE,

    D.vMIN_INVALID_COFETEL + SUM(1) AS vTOTAL_CDRS_CLIENTE,
    D.vMIN_INVALID_COFETEL AS vMIN_INVALID_COFETEL,
    SUM(1) AS vMIN_VALID_COFETEL,

    SUM(DECODE(B.MODALIDAD,'CPP',DECODE(SUBSTR(A.CALLED_PARTY_ON_DEST, 0,6),'140521',1,0),0)) AS vMOVILES_VALIDOS,

    SUM(DECODE(B.MODALIDAD,'CPP',DECODE(SUBSTR(A.CALLED_PARTY_ON_DEST, 0,6),'140521',0,1),0)) AS vMOVILES_INVALIDOS,

    SUM(DECODE(B.MODALIDAD,'FIJO',DECODE(SUBSTR(A.CALLED_PARTY_ON_DEST, 0,5),'14052',1,0),0)) +

    SUM(DECODE(B.MODALIDAD,'MPP',DECODE(SUBSTR(A.CALLED_PARTY_ON_DEST, 0,5),'14052',1,0),0)) AS vFIJOS_VALIDOS,

    SUM(DECODE(B.MODALIDAD,'FIJO',DECODE(SUBSTR(A.CALLED_PARTY_ON_DEST, 0,5),'14052',0,1),0)) +

    SUM(DECODE(B.MODALIDAD,'MPP',DECODE(SUBSTR(A.CALLED_PARTY_ON_DEST, 0,5),'14052',0,1),0)) AS vFIJOS_INVALIDOS FROM
    om_db.CDRS A,
    om_db.cofetel B,
    (SELECT CALL_SOURCE_REGID,
        SUM(SIGN(INSTR(CALLED_PARTY_ON_DEST,'*'))) AS vMIN_INVALID_COFETEL

     FROM om_db.CDRS
    WHERE CALL_SOURCE_REGID IS NOT NULL) D WHERE
  TO_NUMBER(SUBSTR(A.CALLED_PARTY_ON_DEST,-10,10)) between B.NIR_INICIAL AND B.NIR_FINAL
  AND INSTR(CALLED_PARTY_ON_DEST,'*') = 0   AND A.CALL_SOURCE_REGID=D.CALL_SOURCE_REGID   AND A.CALL_SOURCE_REGID IS NOT NULL
GROUP BY
  A.CALL_SOURCE_REGID,
  D.vMIN_INVALID_COFETEL;

END; and it returns the next error:

  • an INTO clause is expected in this SELECT statement

?? what can i do :( ??

Thanks Received on Mon Feb 23 2009 - 17:20:36 CST

Original text of this message