5 Replies Latest reply: Jan 8, 2013 12:12 PM by Warren Tolentino RSS

    wrong number or types of arguments in call to oracle

    983293
      Hi all...
      I've looked around and can't find out what is wrong.
      this function ' CHECK_WF_ALREADY_EXISTS' is inside a packge.
      plz help.!!!!!!!



      **************************ERROR*****************************
      *262 pls-00306 wrong number or types of arguments in call to 'GET_TRANSACTION_STEP_INFO'*
      *******************************************************



      FUNCTION CHECK_WF_ALREADY_EXISTS(P_PERSON_ID IN PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
      O_TRANSACTION_STEP_ID OUT HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE)
      RETURN BOOLEAN IS
      G_PROCEDURE VARCHAR2(250) := 'NULL';
      V_STEP VARCHAR2(2000) := '0';
      V_ITEM_TYPE WF_ITEMS.ITEM_TYPE%TYPE := 'TRANSF_T';
      V_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE := P_PERSON_ID;
      V_ACTIVE_WF_ITEM_LIST HR_WORKFLOW_SERVICE.ACTIVE_WF_ITEMS_LIST;
      V_COUNT_OF_ITEMS NUMBER;
      V_TXN_STEP_ID_LIST HR_UTIL_WEB.G_VARCHAR2_TAB_TYPE;
      V_OBJ_VER_NUMBER_LIST HR_UTIL_WEB.G_VARCHAR2_TAB_TYPE;
      V_ROWS number;
      BEGIN
      G_PROCEDURE := 'Check_Wf_Already_Exists';
      V_STEP := '1';
      V_ACTIVE_WF_ITEM_LIST := HR_WORKFLOW_SERVICE.CHECK_ACTIVE_WF_ITEMS(P_ITEM_TYPE => V_ITEM_TYPE,
      P_PROCESS_NAME => 'TRANSF_PROC',
      P_CURRENT_PERSON_ID => V_PERSON_ID,
      P_ACTIVITY_NAME => 'PROD_FORM');
      V_STEP := '2';
      V_COUNT_OF_ITEMS := V_ACTIVE_WF_ITEM_LIST.COUNT;
      FOR I IN 1 .. V_COUNT_OF_ITEMS LOOP
      V_ROWS := 0;

      HR_TRANSACTION_API.GET_TRANSACTION_STEP_INFO(P_ITEM_TYPE => V_ITEM_TYPE,
      P_ITEM_KEY => V_ACTIVE_WF_ITEM_LIST(I)
      .ACTIVE_ITEM_KEY,
      P_ACTIVITY_ID => V_ACTIVE_WF_ITEM_LIST(I)
      .ACTIVITY_ID,
      P_TRANSACTION_STEP_ID => V_TXN_STEP_ID_LIST,
      P_OBJECT_VERSION_NUMBER => V_OBJ_VER_NUMBER_LIST,
      P_ROWS => V_ROWS);




      FOR J IN 0 .. V_ROWS - 1 LOOP
      O_TRANSACTION_STEP_ID := V_TXN_STEP_ID_LIST(J);
      RETURN TRUE;
      END LOOP;
      END LOOP;
      RETURN FALSE;
      END CHECK_WF_ALREADY_EXISTS;


      *******************************************************
      procedure being called is defined below -->


      procedure get_transaction_step_info
      (p_item_type in varchar2
      ,p_item_key in varchar2
      ,p_activity_id in number
      ,p_transaction_step_id out nocopy hr_util_web.g_varchar2_tab_type
      ,p_object_version_number out nocopy hr_util_web.g_varchar2_tab_type
      ,p_rows out nocopy number);
        • 1. Re: wrong number or types of arguments in call to oracle
          Chanchal Wankhade
          Hi,

          paste the query that you are executing to call package. it would more helpfull to help you.
          • 2. Re: wrong number or types of arguments in call to oracle
            Purvesh K
            Adesh.ajkrj wrote:
            procedure get_transaction_step_info
            (p_item_type in varchar2
            ,p_item_key in varchar2
            ,p_activity_id in number
            ,p_transaction_step_id out nocopy hr_util_web.g_varchar2_tab_type
            ,p_object_version_number out nocopy hr_util_web.g_varchar2_tab_type
            ,p_rows out nocopy number);
            Can you verify if the Package Declaration (specification) section contains the procedure declaration as above?
            • 3. Re: wrong number or types of arguments in call to oracle
              Karthick_Arp
              Welcome to the forum !!

              when ever you get an error message past it with the entire call stack details that you get in the error message. Just the error message is not of much help.

              Show us the code that calls the function that is throwing error.
              • 4. Re: wrong number or types of arguments in call to oracle
                rp0428
                >
                HR_TRANSACTION_API.GET_TRANSACTION_STEP_INFO(P_ITEM_TYPE => V_ITEM_TYPE,
                P_ITEM_KEY => V_ACTIVE_WF_ITEM_LIST(I)
                .ACTIVE_ITEM_KEY,
                P_ACTIVITY_ID => V_ACTIVE_WF_ITEM_LIST(I)
                .ACTIVITY_ID,
                P_TRANSACTION_STEP_ID => V_TXN_STEP_ID_LIST,
                P_OBJECT_VERSION_NUMBER => V_OBJ_VER_NUMBER_LIST,
                P_ROWS => V_ROWS);
                >
                Those lines above are invalid the way you posted them. For example the '.ACTIVITY_ID' is at the beginning of a line.

                Edit your post and add \
                 on the line before and on the line after your code to preserve formatting.
                
                If this is the actual code there is an error
                P_ITEM_KEY => V_ACTIVE_WF_ITEM_LIST(I)
                .ACTIVE_ITEM_KEY,
                If this is the actual code it is ok
                P_ITEM_KEY => V_ACTIVE_WF_ITEM_LIST(I).ACTIVE_ITEM_KEY,
                We can't tell what your code really looks like unless you use the code tags.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                • 5. Re: wrong number or types of arguments in call to oracle
                  Warren Tolentino
                  it will also help us help you if you can provide these info:

                  table structure of WF_ITEMS that you use in your declaration area for this variable v_item_type.

                  V_ITEM_TYPE WF_ITEMS.ITEM_TYPE%TYPE := 'TRANSF_T';

                  and how you create these objects:
                  HR_WORKFLOW_SERVICE.ACTIVE_WF_ITEMS_LIST
                  HR_UTIL_WEB.G_VARCHAR2_TAB_TYPE