Accelerating sp, again!!!
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