Avatar of thota198
thota198
 asked on

Error while executing the proc

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;
Oracle DatabaseSQL

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
Sean Stuber

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?
slightwv (䄆 Netminder)

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
thota198

ASKER
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
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
thota198

ASKER
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
slightwv (䄆 Netminder)

Did we not answer the question that was asked?
thota198

ASKER
ya u did
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
slightwv (䄆 Netminder)

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

Is there anything else we can help you with?