Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Package creation error

user515689Oct 24 2006 — edited Oct 27 2006

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2006
Added on Oct 24 2006
34 comments
2,416 views