title: I want to make this procedure on Oracle SQL
body: <p>I want to make this procedure on Oracle SQL:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE STS_OWNER.PRC_CAMBIO_LDC1 IS 
       CURSOR LDC1 IS 
            select CASE_NO 
            from ldc_cases 
            where case_no in (select barcode 
                              from sts_tracking 
                              where ldc='0' 
                              and duplicated='0'); 
            FOR UPDATE BARCODE; 
       BARCODE VARCHAR2(50); 
  BEGIN 
      OPEN LDC1;
      FETCH LDC1 INTO BARCODE; 
      WHILE LDC1%FOUND LOOP 
           update sts_tracking 
           set ldc= 1 
           WHERE CURRENT LDC1; 
           FETCH LDC1 INTO BARCODE; 
       END LOOP;
       CLOSE LDC1; 
       COMMIT; 
  END;
  </code></pre>