Error while executing the proc

thota198
thota198 used Ask the Experts™
on
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;
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012

Commented:
the error is self-explanatory,  your invocation

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
                                  );


is not correct.  What is dmadm.create_cbn_fulfillment_pr  expecting?

can you post it's definition?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Error should be self-explainitory.  One or more of the paramters do not match.

From a SQL prompt post the results of:

SQL> desc dmadm.create_cbn_fulfillment_pr

Author

Commented:
this is the result from sql for the desc.dmadm.create_dbn_fulfillment_pr
PROCEDURE dmadm.create_cbn_fulfillment_pr
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 I_DEAL_OBJECT_ID               NUMBER                  IN
 I_BOM_LINE_OBJECT_ID           CQ_NUMTABLETYPE         IN
 I_DART_TO_CBN_FLAG             VARCHAR2                IN
 I_CBN_OPTION_CHECK             VARCHAR2                IN     DEFAULT
 I_USER_ID                      VARCHAR2                IN
 I_QUOTE_OBJECT_ID              NUMBER                  IN
 O_ERR_CODE                     NUMBER                  OUT
 O_ERR_MSG                      VARCHAR2                OUT
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
I_BOM_LINE_OBJECT_ID is a CQ_NUMTABLETYPE

You are passing in i_quote_line_object_id which is a cq_cbn_selection_tbl.
Most Valuable Expert 2011
Top Expert 2012
Commented:
the 2nd parameter....

 I_BOM_LINE_OBJECT_ID           CQ_NUMTABLETYPE         IN


that's not what you're passing in

Author

Commented:
one of the developers had changed the code sometime back so i was running the proc with the code tht was there few hours back the issue is solved now anyways thnks for the help
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Did we not answer the question that was asked?

Author

Commented:
ya u did
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
If this has been answered it probably should be closed unless there are outstanding issues.

Is there anything else we can help you with?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial