Friday, 15 May 2015

plsql - PL/SQL Statements ignored & Not enough values - 


  - Below is only to test - take action after removing or retaking movie_rental_sp (movieIdCount out) In number, movie id in-out number) Nomovi is an exception; BEGIN SELECT MOVIE_ID, MM_MOVIE from movie idc in counts (movie_id) where MOVIE_ID = movieID; If movie idcount = 0 then Rise noemi; end if; Exceptions when there is no movie then DBMS_Autput PUT_LINE ('no movie was found'); End; /   
 WARNING: The process created with compilation errors.  
 SQL & gt; Processes to show error MOVIE_RENTAL_SP:  
 line / cl error  
 
 7/1 PL / SQL: SQL statement 9/2 PL / SQL ignored: ORA -09 47: Not enough value   
 
 
 Your selection consists of 2 columns, but only in 1 variable is.   

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)