Home » RDBMS Server » Server Administration » Package Body
Package Body [message #369771] Fri, 06 October 2000 12:52 Go to next message
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
Re: Package Body [message #369772 is a reply to message #369771] Fri, 06 October 2000 13:37 Go to previous message
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
Previous Topic: Can't create trigger. help me!
Next Topic: PL/SQL vs. SQL*Plus explain plans
Goto Forum:
  


Current Time: Thu Mar 28 05:00:11 CDT 2024