PL/SQL Statements ignored & Not enough values

Question

--Below is for testing only - to be deleted later
CREATE OR REPLACE PROCEDURE movie_rental_sp 
    (movieIdCount IN OUT NUMBER,
    movieID IN OUT NUMBER)
IS
noMovie EXCEPTION;
BEGIN
SELECT MOVIE_ID, count(movie_id)
    INTO movieIdCount
    FROM MM_MOVIE
    WHERE MOVIE_ID = movieID;
IF movieIdCount = 0 THEN
RAISE noMovie;
END IF;


EXCEPTION
    WHEN noMovie THEN
    DBMS_OUTPUT.PUT_LINE('No movies found');
END;
/

Warning: Procedure created with compilation errors.

SQL> show errors Errors for PROCEDURE MOVIE_RENTAL_SP:

LINE/COL ERROR

7/1 PL/SQL: SQL Statement ignored 9/2 PL/SQL: ORA-00947: not enough values

score 0 · Answer 1 · answered Mar 27 '13 at 05:05

0

Your SELECT has 2 columns, but your INTO only 1 variable.

answered Mar 27 '13 at 05:05

Daniel

21,933
14
72
101

score 0 · Answer 2 · answered Mar 28 '13 at 02:11

0

Change the select statement to,

SELECT MOVIE_ID, count(movie_id)
INTO movieID , movieIdCount
.....

answered Mar 28 '13 at 02:11

Orangecrush

1,970
2
15
26

PL/SQL Statements ignored & Not enough values

2 Answers2