Stored procedure

Hi ,

Can somebody help me to execute this below stored procedure in database .I am new to stored procedure. In below procedure where I have to declare the 'T_LAST_CHANGE_TS' and where Cursor should be define

  SQL> CREATE OR REPLACE PROCEDURE CM_PROCEDURE (
  2  o_result OUT NUMBER,
  3  i_opcode IN VARCHAR2,
  4  i_city IN VARCHAR2,
  5  i_code IN VARCHAR2,
  6  i_modify_date IN TIMESTAMP,
  7  ib_city IN VARCHAR2,
  8  ib_code IN VARCHAR2 ,
  9  ib_modify_date IN TIMESTAMP
 10  )  is
 11
 12  BEGIN
 13
 14  IF i_opcode='UPDATE' OR i_opcode = 'INSERT' THEN
 15  SELECT * into mms_record
 16  FROM mms_test
 17  WHERE city=i_city