1 Reply Latest reply: Feb 5, 2013 12:57 AM by Amatu Allah Neveen Ebrahim RSS

    How to set and call the value in a parameter list ?

    frank1018
      I want to use RP2RRO.RP2RRO_RUN_PRODUCT to call report. Here is a part of code in rp2rro.pll :
                
             DEFAULT_VALUE('_','GLOBAL.orarrpHostname');
             IF name_in('GLOBAL.orarrpHostname') = '_' THEN
                    orarrpHostname := name_in('PARAMETER.orarrpHostname');
                    COPY(name_in('PARAMETER.orarrpHostname'),'GLOBAL.orarrpHostname');
             ELSE
                   orarrpHostname:= name_in('GLOBAL.orarrpHostname');
             END IF;
      
                DEFAULT_VALUE('_','GLOBAL.orarrpVirtualDir');
             IF name_in('GLOBAL.orarrpVirtualDir') = '_' THEN
                   orarrpVirtualDir := name_in('PARAMETER.orarrpVirtualDir');
                   COPY(name_in('PARAMETER.orarrpPhysicalDir'),'GLOBAL.orarrpVirtualDir');
             ELSE
                   orarrpVirtualDir:= name_in('GLOBAL.orarrpVirtualDir');
             END IF;      
            
            
             DEFAULT_VALUE('_','GLOBAL.orarrpPhysicalDir');
             IF name_in('GLOBAL.orarrpPhysicalDir') = '_' THEN
                   orarrpPhysicalDir := name_in('PARAMETER.orarrpPhysicalDir');
                   COPY(name_in('PARAMETER.orarrpPhysicalDir'),'GLOBAL.orarrpPhysicalDir');
             ELSE
                   orarrpPhysicalDir:= name_in('GLOBAL.orarrpPhysicalDir');
             END IF;
      How to set the parameter list so that
       orarrpHostname := name_in('PARAMETER.orarrpHostname');
      will not report an error :
       FRM-40105: Unable to resolve reference to item PARAMETER.orarrpHostname.
      My current setting is
      ADD_PARAMETER(v_param_list,'orarrpHostname',TEXT_PARAMETER,PLL_WINDOW.orarrpHostname); 
      RP2RRO.RP2RRO_RUN_PRODUCT(REPORTS,'RPT_USER_QUEUE',PLL_WINDOW.g_synchronous,RUNTIME,FILESYSTEM,v_param_list,NULL);
      I'm using 11g, migrated from 6i. RUN_REPORT_OBJECT was replaced by RP2RRO.RP2RRO_RUN_PRODUCT.

      Do I need to modify the code in rp2rro.pll ? And what should I pay attention to ?

      Thanks.