Retail Merchandising System (MOSC)

MOSC Banner

UPDATE statement with NVL in where clause

edited Apr 18, 2017 5:25AM in Retail Merchandising System (MOSC) 1 commentAnswered

My update statement wont seem to finish its session with I use NVL in where clause.

   OPEN C_CHK_ERR_UPD;

   LOOP

      FETCH C_CHK_ERR_UPD BULK COLLECT INTO LP_item LIMIT i_commit_max_ctr;

      EXIT WHEN LP_item.COUNT = 0;

      FORALL i IN 1 .. LP_item.COUNT

         UPDATE xlll_st_item_master

            SET processed_ind = 'E'

          WHERE nvl(item, 'NA') = nvl(LP_item(i), 'NA')

            AND processed_ind = 'N';

      COMMIT;

   END LOOP;

   CLOSE C_CHK_ERR_UPD;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center