Click here to Skip to main content
15,884,099 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
 DECLARE
 TYPE t_cntry_cd          is TABLE OF OFFER_PD_DETAIL.cntry_cd%type index by BINARY_INTEGER;
 TYPE t_curr_cd           is TABLE OF OFFER_PD_DETAIL.curr_cd%type index by BINARY_INTEGER;
  TYPE t_price_term_cd     is TABLE OF OFFER_PD_DETAIL.price_term_cd%type index by BINARY_INTEGER;
 TYPE t_price_list_cd     is TABLE OF OFFER_PD_DETAIL.price_list_cd%type index by BINARY_INTEGER;
 Type t_BD_NR_Type is table of  DEAL.BD_NR%type index by pls_integer;
 OUT_STATUS VARCHAR2(200):=NULL;
  OUT_ERROR_MESSGE VARCHAR2(200):=NULL;
  OUT_OFFERID VARCHAR2(200):=NULL;
  IN_OFFERID_DESC VARCHAR2(350);
  IN_CUSTCHANNEL_ID NUMBER;
  IN_OFFER_PRICING_CD NUMBER;
  IN_OFFER_GEO_SCOPE_CD VARCHAR2(100);
  IN_OFFER_CUST_SCOPE_CD VARCHAR2(100);
  IN_OFFER_PRG_CD VARCHAR2(100);
  IN_OFFER_LOCAL_CD VARCHAR2(100);
  IN_BD_ID  t_BD_NR_Type;
  IN_OFFER_CLASS VARCHAR2(1);
  IN_OFFER_CNTRY_CD VARCHAR2(2);
  IN_USER_COMMENTS VARCHAR2(2000);
  IN_CREATE_HP_EMP_NR NUMBER;
  IN_CONTRACT_ID VARCHAR2(12);
  IN_CPLTID VARCHAR2(6);
  IN_TIER_PROFILE_ID NUMBER;
  IN_PA_CAC_CD VARCHAR2(1);
  IN_PA_COUNTRY_CD VARCHAR2(4);
  IN_OFR_PRICING_LOGIC_ID NUMBER;
  IN_SHORTCUT_PROFILE_ID NUMBER;
  IN_PS_ROUNDING_FL VARCHAR2(1);
   IN_cntry_cd                t_cntry_cd;    
    IN_curr_cd                t_curr_cd;
    IN_price_term_cd             t_price_term_cd;
    IN_price_list_cd            t_price_list_cd;
	 IN_IQ_CACHE_FL VARCHAR2(1);
      IN_HP2B_FL CHAR(1);

BEGIN
     PKG_MANAGE_OFFERS_TEST.CREATE_OFFER_T(
   IN_OFFERID_DESC => 'Testing',
    IN_CUSTCHANNEL_ID => '1',
    IN_OFFER_PRICING_CD => '4',
    IN_OFFER_GEO_SCOPE_CD => 'scope',
    IN_OFFER_CUST_SCOPE_CD => 'cust',
    IN_OFFER_PRG_CD => 'prg',
    IN_OFFER_LOCAL_CD => 'local',
    IN_BD_ID => '234567',
    IN_OFFER_CLASS => 'e',
    IN_OFFER_CNTRY_CD => 'eu',
    IN_USER_COMMENTS => 'test',
    IN_CREATE_HP_EMP_NR => '1',
    IN_CONTRACT_ID => 'gyyuuhb',
    IN_CPLTID => 'yuioty',
    IN_TIER_PROFILE_ID => '6',
    IN_PA_CAC_CD => '3',
    IN_PA_COUNTRY_CD => 'tryu',
    IN_OFR_PRICING_LOGIC_ID => '5',
    IN_SHORTCUT_PROFILE_ID => '6',
    IN_PS_ROUNDING_FL => 'Y',
    IN_CNTRY_CD => 'CD',
    IN_CURR_CD => 'CD',
    IN_PRICE_TERM_CD => 'CD',
    IN_PRICE_LIST_CD => 'CD',
    IN_IQ_CACHE_FL => 'N',
    IN_HP2B_FL => 'Y');

END;


What I have tried:

yes but i am facing some issue
Posted
Comments
RedDk 7-Oct-20 13:37pm    
Formatting issues with your paste of (oracle?) code into the control above are interfering with my understanding of the problem you encounter ("[Error] execution (39: 6): ORA-06550: Line 39, column 6: PLS-00306: wrong number or types of arguments in call to 'CREATE_OFFER_T'")
Member 14958392 8-Oct-20 0:51am    
i have passed IN_cntry_cd t_cntry_cd;
IN_curr_cd t_curr_cd;
IN_price_term_cd t_price_term_cd;
IN_price_list_cd t_price_list_cd; 4 parameters in a collection type parameters , but didn't know how to test it with anonymous block
Wendelius 7-Oct-20 14:29pm    
What does the definition of the PKG_MANAGE_OFFERS_TEST.CREATE_OFFER_T look like?
Member 14958392 8-Oct-20 0:50am    
hi wendelius
i have passed 4 in parameter in the collection type format, i need help like how to modify to pass the values for the arrays.
Wendelius 8-Oct-20 11:30am    
Not sure if I understand your reply, but based on the error message you have a mismatch in the parameters compared to the call.

Can you post the definition for the PKG_MANAGE_OFFERS_TEST.CREATE_OFFER_T, In other words the header of the package

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900