• Create a Database connection to the Oracle schema that has the stored Procedure.   To the end of the Database connection add “;PLSQLRSet=1”
• Create a database Configuration  with the Database connection created above and in the SQL Statement of the data configuration, call the Stored Procedure in Oracle as  :

                                     {Call GetEmp (?)}

When STATISTICA prompts to turn off fully qualified table/column names, click No. This will then bring up an OLEDB Parameters dialog.

• Hit the “Insert” key on the keyboard. This will bring up another OLEDB Parameter dialog:

  

It has been confirmed that the name differing from the actual Oracle parameter name doesn’t make a difference to the results. So the name could be anything. Set the type to the Parameter Data Type and type in a value for the parameter and click ok.

Click Ok on the OLEDB Parameters dialog and commit the data configuration.

• Click on Explore with Option and enable the ‘Show OLEDB Parameter dialog’ check Box.

  

  STATISTICA will then show the OLEDB Parameter dialog that can be edited at runtime while exploring the data configuration.

Note that this option is not available on STATISTICA 12 Update 8 “Explore with Option” in the data configuration. However, On STATISTICA 12 Update 8, if an analysis that is built off the Oracle Stored Procedure with OLEDB Parameters the option “Show OLEDB parameters dialog” can be enabled. When running the analysis, the OLEDB Parameters will show up at runtime.