Re: Accelerating sp, again!!!

From: <johnbhurley_at_sbcglobal.net>
Date: Mon, 23 Feb 2009 17:05:12 -0800 (PST)
Message-ID: <78e052e8-dabe-4fa9-9900-8064d7d2515b_at_m42g2000yqb.googlegroups.com>

On Feb 23, 6:20 pm, Jorge Reyes <jorg_re..._at_hotmail.com> wrote:
> 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

In PLSQL you use a SELECT statement either in a CURSOR or you use it directly ( as in SELECT etc INTO something ).

You don't have either one of those constructs therefore you get the error. Received on Mon Feb 23 2009 - 19:05:12 CST