CREATE OR REPLACE PROCEDURE EV_Update
(p_CERTNUM IN VARCHAR2, p_ELECTION IN VARCHAR2, p_PRECINCT IN NUMBER, 
p_GRP IN VARCHAR2, p_SEQ_STYLE IN VARCHAR2, p_SEL_CODE IN VARCHAR2, 
p_PARTY IN VARCHAR2, p_EARLY_LOC IN VARCHAR2, 
p_DT_VOTE IN DATE,p_APPNUM IN NUMBER) 
IS
BEGIN
UPDATE evhist 
SET CERTNUM = p_CERTNUM, ELECTION = p_ELECTION, 
PRECINCT = p_PRECINCT, GRP = p_GRP, SEQ_STYLE = p_SEQ_STYLE, 
SEL_CODE = p_SEL_CODE, PARTYCODE = p_PARTY, EARLY_LOC = p_EARLY_LOC, 
DT_VOTE = p_DT_VOTE, APPNUM = p_APPNUM 
WHERE (CERTNUM = p_CERTNUM AND ELECTION = p_ELECTION);

IF (SQL%ROWCOUNT = 0 ) THEN
INSERT INTO evhist 
(CERTNUM, ELECTION, PRECINCT, GRP, SEQ_STYLE,SEL_CODE,  PARTYCODE, EARLY_LOC, DT_VOTE, APPNUM) 
VALUES 
(p_CERTNUM, p_ELECTION, p_PRECINCT, 
p_GRP,p_SEQ_STYLE,p_SEL_CODE, p_PARTYCODE, 
p_EARLY_LOC, p_DT_VOTE, p_APPNUM);

END IF;
END EV_Update;
/

SQL> prompt: CREATE OR REPLACE PROCEDURE EV_Update
: CREATE OR REPLACE PROCEDURE EV_Update
SQL> (p_CERTNUM IN VARCHAR2, p_ELECTION IN VARCHAR2, p_PRECINCT IN NUMBER, 
  2  p_GRP IN VARCHAR2, p_SEQ_STYLE IN VARCHAR2, p_SEL_CODE IN VARCHAR2, 
  3  p_PARTY IN VARCHAR2, p_EARLY_LOC IN VARCHAR2, 
  4  p_DT_VOTE IN DATE,p_APPNUM IN NUMBER) 
  5  IS
  6  BEGIN
  7  UPDATE evhist 
  8  SET CERTNUM = p_CERTNUM, ELECTION = p_ELECTION, 
  9  PRECINCT = p_PRECINCT, GRP = p_GRP, SEQ_STYLE = p_SEQ_STYLE, 
 10  SEL_CODE = p_SEL_CODE, PARTYCODE = p_PARTY, EARLY_LOC = p_EARLY_LOC, 
 11  DT_VOTE = p_DT_VOTE, APPNUM = p_APPNUM 
 12  WHERE (CERTNUM = p_CERTNUM AND ELECTION = p_ELECTION);
(p_CERTNUM IN VARCHAR2, p_ELECTION IN VARCHAR2, p_PRECINCT IN NUMBER,
 *
ERROR at line 1:
ORA-00928: missing SELECT keyword


SQL> 
SQL> IF (SQL%ROWCOUNT = 0 ) THEN
SP2-0734: unknown command beginning "IF (SQL%RO..." - rest of line ignored.
SQL> INSERT INTO evhist 
  2  (CERTNUM, ELECTION, PRECINCT, GRP, SEQ_STYLE,SEL_CODE,  PARTYCODE, EARLY_LOC, DT_VOTE, APPNUM) 

  3  VALUES 
  4  (p_CERTNUM, p_ELECTION, p_PRECINCT, 
  5  p_GRP,p_SEQ_STYLE,p_SEL_CODE, p_PARTYCODE, 
  6  p_EARLY_LOC, p_DT_VOTE, p_APPNUM);
p_EARLY_LOC, p_DT_VOTE, p_APPNUM)
                        *
ERROR at line 6:
ORA-00984: column not allowed here


SQL> 
SQL> END IF;
SP2-0042: unknown command "END IF" - rest of line ignored.
SQL> END EV_Update;
SP2-0734: unknown command beginning "END EV_Upd..." - rest of line ignored.

SQL> CREATE OR REPLACE PROCEDURE EV_Update
  2  (p_CERTNUM IN VARCHAR2, 
  3  p_ELECTION IN VARCHAR2, 
  4  p_PRECINCT IN NUMBER, 
  5  p_GRP IN VARCHAR2, 
  6  p_SEQ_STYLE IN VARCHAR2, 
  7  p_SEL_CODE IN VARCHAR2, 
  8  p_PARTY IN VARCHAR2, 
  9  p_EARLY_LOC IN VARCHAR2, 
 10  p_DT_VOTE IN DATE,
 11  p_APPNUM IN NUMBER) 
 12  IS
 13  BEGIN
 14  UPDATE evhist 
 15  SET CERTNUM = p_CERTNUM, ELECTION = p_ELECTION, 
 16  PRECINCT = p_PRECINCT, GRP = p_GRP, SEQ_STYLE = p_SEQ_STYLE, 
 17  SEL_CODE = p_SEL_CODE, PARTYCODE = p_PARTY, EARLY_LOC = p_EARLY_LOC, 
 18  DT_VOTE = p_DT_VOTE, APPNUM = p_APPNUM 
 19  WHERE (CERTNUM = p_CERTNUM AND ELECTION = p_ELECTION);
 20  
 21  IF (SQL%ROWCOUNT = 0 ) THEN
 22  INSERT INTO evhist 
 23  (CERTNUM, ELECTION, PRECINCT, GRP, SEQ_STYLE,SEL_CODE,  PARTYCODE, EARLY_LOC, DT_VOTE, APPNUM) 

 24  VALUES 
 25  (p_CERTNUM, p_ELECTION, p_PRECINCT, 
 26  p_GRP,p_SEQ_STYLE,p_SEL_CODE, p_PARTYCODE, 
 27  p_EARLY_LOC, p_DT_VOTE, p_APPNUM);
 28  END IF;
 29  END;
 30  /

Warning: Procedure created with compilation errors.

SQL> show errors procedure ev_update;
Errors for PROCEDURE EV_UPDATE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
22/1     PL/SQL: SQL Statement ignored
26/31    PL/SQL: ORA-00984: column not allowed here