If “OR REPLACE” is specified , remove “OR REPLACE”. If “AS” token is specified, remove “AS” as with “IS” token. Add “END_PROC” after “END;” token. Or if “procedure_name” is specified after END , replace “procedure_name” to “END_PROC”.

Oracle:

CREATE [OR REPLACE]
PROCEDURE procedure_name(…) {IS| AS}
BEGIN…..
END [procedure_name];

HiRDB:

CREATE PROCEDURE  procedure_name(…) 
 BEGIN ・・・・
 END;
END_PROC;

EXAMPLE:

Oracle:

CREATE OR REPLACE PROCEDURE ex_emp (employee_id float) AS 
 tot_emps float; 
 BEGIN 
    EXIT; 
 END;

HiRDB:

CREATE PROCEDURE ex_emp (IN employee_id float) 
 BEGIN 
      DECLARE tot_emps float; 
      LEAVE; 
 END
END_PROC;