Search code examples
plsqlplsql-package

Error on sysdate and does not compile


I have a sample pl/sql that does not compile. i have 4 errors and cannot figure out where it is. i have attempted process of isolation and yet i cannot find out the missing piece

CREATE OR REPLACE PACKAGE TestLocks AS


  PROCEDURE testBlocks(in_iteration IN number, in_loop_no IN number, z OUT number) ;
  END TestLocks;

/

CREATE OR REPLACE PACKAGE TestLocks IS
 PROCEDURE testBlocks(in_iteration IN NUMBER, in_loop_no IN NUMBER, z OUT NUMBER) IS
BEGIN
  startdate:=sysdate;
update test_locks
set last_datetime=startdate
 where loop_no =in_loop_no;
 -- do loop


 FOR i IN in_iteration  LOOP
 update test_locks
set last_datetime=startdate
 where loop_no =in_iteraction;

  END LOOP;
END;


END TestLocks;
/

Solution

  • CREATE OR REPLACE PACKAGE TestLocks AS
      PROCEDURE testBlocks(in_iteration IN number, in_loop_no IN number, z OUT number) ;
    END TestLocks;
    
    CREATE OR REPLACE PACKAGE BODY TestLocks IS
     PROCEDURE testBlocks(in_iteration IN NUMBER, in_loop_no IN NUMBER, z OUT NUMBER) IS
    startdate date;
    BEGIN
      startdate:=sysdate;
    update test_locks
    set last_datetime=startdate
     where loop_no =in_loop_no;
     -- do loop
    
     FOR i IN 1..in_iteration  LOOP
         update test_locks
        set last_datetime=startdate
         where loop_no =in_iteraction;
    
      END LOOP;
    END;
    END TestLocks;