I had done something like this before, but successfully, with no errors.
Any idea why I'm getting the error now? It's telling me I have failed to declare the package name.
Here's the code
PROCEDURE insert_vote_dev
(p_ctid IN NUMBER,
p_busvp IN VARCHAR2,
p_branch IN VARCHAR2,
p_vote IN VARCHAR2) IS
BEGIN INSERT INTO votetbl_dev (title, branch, id, vote)
VALUES (p_busvp, p_branch, p_ctid, p_vote);
END;
-- insert_vote_dev
PROCEDURE update_cc_admin_dev(p_ctrl IN NUMBER) IS
BEGIN
UPDATE change_control_admin_dev SET status1 = 'Active',status2 = 'Approved' WHERE
change_ctrl_id = p_ctrl;
END;
PROCEDURE ccstatus_proc_dev
(p_ctid IN NUMBER,
p_busvp IN VARCHAR2,
p_branch IN VARCHAR2,
p_vote IN VARCHAR2)
IS
BEGIN insert_vote_dev(p_ctid, p_busvp, p_branch, p_vote);
END;
-- ccstatus_proc 4 param
PROCEDURE ccstatus_proc_dev
(p_ctid IN NUMBER,
p_busvp IN VARCHAR2,
p_branch IN VARCHAR2,
p_vote IN VARCHAR2,
p_ctid2 IN NUMBER) IS
BEGIN insert_vote_dev(p_ctid, p_busvp, p_branch, p_vote);
update_cc_admin_dev(p_ctid2);
END;
-- ccstatus_proc 5 param
END; -- Package Body
/
Any insight is appreciated!
Here are the errors!
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00201: identifier 'STAT_PKG_DEV' must be declared
1/14 PLS-00304: cannot compile body of 'STAT_PKG_DEV' without its
specification