SQL> create or replace PACKAGE BODY pkg
  2  FUNCTION f RETURN NUMBER IS
  3  v_proc_name varchar2(40) := 'S';
  4  v_row_count number := 0;
  5  no_match EXCEPTION;
  6  BEGIN
  7  dbms_output.put_line('-----------------------------------------------------
-------');
  8  dbms_output.put_line('Process: ' || v_proc_name);
  9  dbms_output.put_line('-----------------------------------------------------
-------');
 10  dbms_output.put_line('Process started at ' ||
 11  to_char(SYSDATE, 'mm/dd/yyyy hh24:mi:ss'));
 12  dbms_output.put_line('-----------------------------------------------------
-------');
 13  dbms_output.put_line('update missing fields to t');
 14  MERGE INTO tar t --line 32
 15  USING (SELECT x,y,z
 16  FROM src) s
 17  ON (t.a = s.b AND t.c = s.d)
 18  WHEN MATCHED THEN
 19  UPDATE
 20  SET t.e = s.x,
 21  t.f =s.y,
 22  t.g=s.z
 23  WHEN NOT MATCHED THEN
 24  raise no_match; --line 59
 25  v_row_count := SQL%ROWCOUNT;
 26  COMMIT;
 27  RETURN 0;
 28  EXCEPTION
 29  WHEN no_match THEN
 30  DBMS_OUTPUT.PUT_LINE('-----------------------------------------------------
-------');
 31  dbms_output.put_line ('There is no match for the records in source and targ
et');
 32  DBMS_OUTPUT.PUT_LINE('-----------------------------------------------------
-------');
 33  DBMS_OUTPUT.PUT_LINE('Process Ended at '||TO_CHAR(sysdate,'MM/DD/YYYY HH24:
MI:SS'));
 34  RETURN - 1;
 35  RAISE;
 36  WHEN OTHERS THEN
 37  dbms_output.put_line('Process Ended at: ' || to_char(sysdate,'YYYYMMDD HH24
:MI')) ;
 38  dbms_output.put_line('Error message: ' || sqlcode || sqlerrm) ;
 39  dbms_output.put_line(rtrim(dbms_utility.format_error_stack,chr(10))) ;
 40  dbms_output.put_line(rtrim(dbms_utility.format_error_backtrace,chr(10))) ;
 41  dbms_output.new_line;
 42  ROLLBACK ;
 43  RETURN - 1;
 44  RAISE;
 45  END f;
 46  END pkg;
 47  /

Warning: Package Body created with compilation errors.

When I try to run the above package body i am getting error as
LINE/COL ERROR
-----------------------------------------------------------------
14/1 PL/SQL: SQL Statement ignored
24/1 PL/SQL: ORA-00905: missing keyword

WHEN NOT MATCHED THEN
   [b]RAISE no_match; --line 59[/b]   v_row_count := SQL%ROWCOUNT;
   COMMIT;