DECLARE
p_price_list_hdr_id price_list_hdr.price_list_hdr_id%TYPE;
p_wht_tough_disc_amt price_list_hdr.wht_tough_disc_amt%TYPE;
p_wht_damp_disc_amt price_list_hdr.wht_damp_disc_amt%TYPE;
p_wht_stone_disc_amt price_list_hdr.wht_stone_disc_amt%TYPE;
p_durum_tough_disc_amt price_list_hdr.durum_tough_disc_amt%TYPE;
p_durum_damp_disc_amt price_list_hdr.durum_damp_disc_amt%TYPE;
p_durum_stone_disc_amt price_list_hdr.durum_stone_disc_amt%TYPE;
p_bly_tough_disc_amt price_list_hdr.bly_tough_disc_amt%TYPE;
p_bly_damp_disc_amt price_list_hdr.bly_damp_disc_amt%TYPE;
p_bly_stone_disc_amt price_list_hdr.bly_stone_disc_amt%TYPE;
p_desigtd_bly_tough_disc_amt price_list_hdr.desigtd_bly_tough_disc_amt%TYPE;
p_desigtd_bly_damp_disc_amt price_list_hdr.desigtd_bly_damp_disc_amt%TYPE;
p_price_list_status_type_name price_list_hdr.price_list_status_type_name%TYPE;
p_load_dtm price_list_hdr.load_dtm%TYPE;
p_user_name price_list_hdr.user_name%TYPE;
p_wht_indr_flag price_list_hdr.wht_indr_flag%TYPE;
p_durum_indr_flag price_list_hdr.durum_indr_flag%TYPE;
p_bly_indr_flag price_list_hdr.bly_indr_flag%TYPE;
p_desigtd_bly_indr_flag price_list_hdr.desigtd_bly_indr_flag%TYPE;
p_load_type_name price_list_hdr.load_type_name%TYPE;
p_wht_basis_num price_list_hdr.wht_basis_num%TYPE;
p_durum_basis_num price_list_hdr.durum_basis_num%TYPE;
p_bly_basis_num price_list_hdr.bly_basis_num%TYPE;
p_desigtd_bly_basis_num price_list_hdr.desigtd_bly_basis_num%TYPE;
p_src_file_path_desc price_list_hdr.src_file_path_desc%TYPE;
p_pool_part_code price_list_hdr.pool_part_code%TYPE;
p_sct_price_list_name price_list_hdr.sct_price_list_name%TYPE;
p_sct_effctv_dtm price_list_hdr.sct_effctv_dtm%TYPE;
p_row_cnt_qty price_list_hdr.row_cnt_qty%TYPE;
p_price_sum_amt price_list_hdr.price_sum_amt%TYPE;
BEGIN
p_price_list_hdr_id := '200804';
p_wht_tough_disc_amt := 8.00;
p_wht_damp_disc_amt := -11.50;
p_wht_stone_disc_amt := -5.00;
p_durum_tough_disc_amt := -7.00;
p_durum_damp_disc_amt := -10.50;
p_durum_stone_disc_amt := -4.00;
p_bly_tough_disc_amt := -6.00;
p_bly_damp_disc_amt := -9.50;
p_bly_stone_disc_amt := -3.00;
p_desigtd_bly_tough_disc_amt := -5.00;
p_desigtd_bly_damp_disc_amt := -8.50;
p_price_list_status_type_name := 'Initial';
p_load_dtm := '06/11/2008';
p_user_name := 'gxgervais';
p_wht_indr_flag := 'Y';
p_durum_indr_flag := 'Y';
p_bly_indr_flag := 'Y';
p_desigtd_bly_indr_flag := 'Y';
p_load_type_name := 'Initial';
p_wht_basis_num := 0;
p_durum_basis_num := 0;
p_bly_basis_num := 0;
p_desigtd_bly_basis_num := 0;
p_src_file_path_desc := 'C:\Backups\Test.xls';
p_pool_part_code := 'A';
p_sct_price_list_name := 'Initial Price List for Aug 2008 (test)';
p_sct_effctv_dtm := null;
p_row_cnt_qty := 0;
p_price_sum_amt := 0;
insert_price_list_hdr (
p_price_list_hdr_id,
p_wht_tough_disc_amt,
p_wht_damp_disc_amt,
p_wht_stone_disc_amt,
p_durum_tough_disc_amt,
p_durum_damp_disc_amt,
p_durum_stone_disc_amt,
p_bly_tough_disc_amt,
p_bly_damp_disc_amt,
p_bly_stone_disc_amt,
p_desigtd_bly_tough_disc_amt,
p_desigtd_bly_damp_disc_amt,
p_price_list_status_type_name,
p_load_dtm,
p_user_name,
p_wht_indr_flag,
p_durum_indr_flag,
p_bly_indr_flag,
p_desigtd_bly_indr_flag,
p_load_type_name,
p_wht_basis_num,
p_durum_basis_num,
p_bly_basis_num,
p_desigtd_bly_basis_num,
p_src_file_path_desc,
p_pool_part_code,
p_sct_price_list_name,
p_sct_effctv_dtm,
p_row_cnt_qty,
p_price_sum_amt
);
END;
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
your procedure isn't a standalone procedure, it's a member of a package so you must specify the package
change this...
DbCommand dbCommand = db.GetStoredProcCommand("i
to
DbCommand dbCommand = db.GetStoredProcCommand("P