troubleshooting Question

Error while executing the proc

Avatar of thota198
thota198 asked on
Oracle DatabaseSQL
9 Comments2 Solutions536 ViewsLast Modified:
Hi Folks
   while running the below proc im getting the following error
    Execution (26: 3): ORA-06550: line 26, column 3:
PLS-00306: wrong number or types of arguments in call to 'CREATE_CBN_FULFILLMENT_PR'
ORA-06550: line 26, column 3:
PL/SQL: Statement ignored
 
 DECLARE
  i_deal_object_id              NUMBER;
  i_quote_line_object_id        cq_cbn_selection_tbl;
  i_dart_to_cbn_flag            VARCHAR2 (32767);
  i_cbn_option_check            VARCHAR2 (32767);
  i_user_id                     VARCHAR2 (32767);
  i_quote_object_id             NUMBER;
  o_err_code                    NUMBER;
  o_err_msg                     VARCHAR2 (32767);
BEGIN


  i_deal_object_id := 2255986764;
  -- I_QUOTE_LINE_OBJECT_ID := NULL;  Modify the code to initialize this parameter
  i_dart_to_cbn_flag := 'Y';
  i_cbn_option_check := 'P';
  i_user_id := 'dpandhi';
  i_quote_object_id := 2255986945;
 -- o_err_code := NULL;
--  o_err_msg := NULL;
 
     i_quote_line_object_id := cq_cbn_selection_tbl (cq_cbn_selection_obj (2255987624, 1));

 -- i_quote_line_object_id := cq_cbn_selection_tbl (cq_cbn_selection_obj (2255987879, 0));

  dmadm.create_cbn_fulfillment_pr (i_deal_object_id,
                                   i_quote_line_object_id,
                                   i_dart_to_cbn_flag,
                                   i_cbn_option_check,
                                   i_user_id,
                                   i_quote_object_id,
                                   o_err_code,
                                   o_err_msg
                                  );
  --COMMIT;
  dbms_output.put_line(o_err_code);
  dbms_output.put_line(o_err_msg);
END;
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros