Can someone help me on Cursor For Loops?!?!?!

[gandolf989]

I'm using SQL+ and it doesnt like the commands you told me to to enter after the begin statement.

I'm not sure what you mean.

DECLARE
   CURSOR STK_CURSOR IS
      SELECT * FROM MM_MOVIE
         FOR UPDATE NOWAIT;
BEGIN
   DBMS_OUTPUT.ENABLE(1000000); 
   FOR STK_REC IN STK_CURSOR LOOP
      IF STK_REC.STK_FLAG > 75 THEN
         dbms_output.put_line ('STK_REC.STK_FLAG > 75 - ' || STK_REC.STK_FLAG);
         UPDATE MM_MOVIE
            SET STK_FLAG = '*'
          WHERE CURRENT OF STK_CURSOR;
         dbms_output.put_line ('Rows updated: ' || SQL%ROWCOUNT);
      ELSE 
         dbms_output.put_line ('STK_REC.STK_FLAG <= 75 - ' || STK_REC.STK_FLAG);
         UPDATE MM_MOVIE
            SET STK_FLAG = NULL
          WHERE CURRENT OF STK_CURSOR;
         dbms_output.put_line ('Rows updated: ' || SQL%ROWCOUNT);
      END IF;
   END LOOP;

   COMMIT;
END;
/