Re: NEED HELP WITH THIS PROCEDURE

From: rany <rany_at_tx.technion.ac.il>
Date: Sat, 09 May 1998 10:38:47 +0300
Message-ID: <35540807.F77F2AF5@tx.technion.ac.il>

Dominick LoGiudice wrote:

> When I compile the procedure below I get error messages saying
>
> 1):PLS-00428: an INTO clause is expected in this SELECT statement
> (2):PL/SQL: SQL Statement ignored
>
> How should I code this ?
> Thanks
>
>

   I cannot understand the problem ....    what the error means is that the results of the select should     be put in variables ....
    When you use SELECT clause in PL/SQL in must have     the INTO keyword .... which will specify the variable name     which will contain the result ...
    you should define variable of the result type of each     of your SELECT clause ... and put this variable after the INTO     keyword ...
    it seems rather strange that you didn't use the results     of your SELECT clauses anywhere ....

Rani Received on Sat May 09 1998 - 02:38:47 CDT