2 Replies Latest reply: Dec 27, 2013 9:01 AM by Frank Kulash RSS

    help me to run pkg via procedure

    softsuresh

      i have a package :  

       

      create or replace

      PACKAGE SUBS_INS_API_SS

      IS

      PROCEDURE SUBSCRIBER_INS_SS

          (SOURCE_SYS_ID IN VARCHAR2,

          TRACKING_ID   IN VARCHAR2,

          ACCOUNT_NO IN VARCHAR2,

          prepaidActDevDetails_tab IN prepaidActDeviceDetails_tabobj,

          ERROR_CODE OUT VARCHAR2);

      END SUBS_INS_API_SS;

      -------------------------------------------------------

       

      pprepaidActDevDetails_tab  is a plsql table and  prepaidActDeviceDetails_tabobj is an object it contains few variable's check below procedure.

       

      -----------------------------------------------------------

       

      If i run the above package by giving input's via the below procedure. Then i got an error:

      • Error(35,7): PLS-00306: wrong number or types of arguments in call to 'SUBSCRIBER_INS_SS'

       

      create or replace

      PROCEDURE SAMPLE_EXC

      IS

       

       

      ERRORCOD VARCHAR2 (30):= NULL ;

      SOURCE_SYS_ID1 VARCHAR2 (30):= '5698745';

      TRACKING_ID1   VARCHAR2 (30):= '5874125';

      ACCOUNT_NO1    VARCHAR2 (30):= NULL;

      prepaidAccountDetails1         prepaid_act_dvc_details_obj

                                             := prepaid_act_dvc_details_obj  ('CM00000006184',  '00:1C:15:15:15:42', NULL,  'HSD',  NULL, '1',  NULL,  '12',  NULL, NULL);

       

      BEGIN

       

       

            SUBS_INS_API_SS.SUBSCRIBER_INS_SS(SOURCE_SYS_ID1, TRACKING_ID1, ACCOUNT_NO1, prepaidAccountDetails1, ERRORCOD);

             DBMS_OUTPUT.PUT_LINE( ERRORCOD);                                 

                                             

      END;

       

      please help me to run this package via the procedure.