OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Package Body

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Package Body [message #369771]

Fri, 06 October 2000 12:52

rivers
Messages: 4
Registered: October 2000

Junior Member

I am getting an error that says that the cursor or subprogram was declared in the package specification but its not defined in the package body.PROCEDURE lead_entry(p_lead_id IN NUMBER DEFAULT NULL, p_customer IN VARCHAR2 DEFAULT NULL,
p_cust_type IN NUMBER DEFAULT NULL, p_cust_addr_1 IN VARCHAR2 DEFAULT NULL,
p_cust_addr_2 IN VARCHAR2 DEFAULT NULL, p_city IN VARCHAR2 DEFAULT NULL,
p_state IN VARCHAR2 DEFAULT NULL, p_zip_code IN VARCHAR2 DEFAULT NULL,
p_country_code IN VARCHAR2 DEFAULT NULL, p_agency_id IN VARCHAR2 DEFAULT NULL,
p_type_id IN NUMBER DEFAULT NULL, p_title IN VARCHAR2 DEFAULT NULL,
p_description IN VARCHAR2 DEFAULT NULL, p_sai_role IN VARCHAR2 DEFAULT NULL,
p_est_total_value IN VARCHAR2 DEFAULT NULL, p_primary_bus_area IN VARCHAR2 DEFAULT NULL,
p_roi_to_sai IN VARCHAR2 DEFAULT NULL, p_proc_type IN VARCHAR2 DEFAULT NULL,
p_proc_stat IN VARCHAR2 DEFAULT NULL, p_sic IN VARCHAR2 DEFAULT NULL,
p_size_std IN VARCHAR2 DEFAULT NULL, p_rfp_rel IN VARCHAR2 DEFAULT NULL,
p_est_award_date IN VARCHAR2 DEFAULT NULL, p_perf_pd IN VARCHAR2 DEFAULT NULL,
p_est_draft_rel IN VARCHAR2 DEFAULT NULL, p_est_proposal_due_date IN VARCHAR2 DEFAULT NULL,
p_est_start_date IN VARCHAR2 DEFAULT NULL, p_contract_type IN VARCHAR2 DEFAULT NULL,
p_lead_source IN VARCHAR2 DEFAULT NULL, p_contact_name IN secure.msg_arr DEFAULT empty,
p_contact_type IN secure.msg_arr DEFAULT empty, p_contact_title IN secure.msg_arr DEFAULT empty,
p_contact_phone IN secure.msg_arr DEFAULT empty, p_contact_email IN secure.msg_arr DEFAULT empty,
p_remarks IN VARCHAR2 DEFAULT NULL, p_lead_rvw IN VARCHAR2 DEFAULT NULL,
p_next_sched_rvw IN VARCHAR2 DEFAULT NULL, p_win_prob IN VARCHAR2 DEFAULT NULL,
p_fund_prob IN VARCHAR2 DEFAULT NULL, p_competiton IN VARCHAR2 DEFAULT NULL, p_contact_history IN VARCHAR2 DEFAULT NULL,
p_teaming IN VARCHAR2 DEFAULT NULL, p_charge_number IN NUMBER DEFAULT NULL, p_bp_budget IN NUMBER DEFAULT NULL);

the error appears on a line that states the following

FUNCTION get_lead_rec(p_id IN NUMBER) RETURN bus_lead%ROWTYPE IS

Report message to a moderator

Re: Package Body [message #369772 is a reply to message #369771]

Fri, 06 October 2000 13:37

Rajeev
Messages: 34
Registered: January 2000

Member

CHECK THE FUNCTION IS DEFINED IN THE PACKAGE BODY
OR NOT...
I AM SURE U HAVE A FUNCTION DEFINED IN PACKEGE SPECIFICATION BUT NOT IN THE PACKAGE BODY..
HOPE THIS HELPS
RAJEEV

Report message to a moderator

Previous Topic:	Can't create trigger. help me!
Next Topic:	PL/SQL vs. SQL*Plus explain plans

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 11:05:55 CST 2024