How to Pass Parameters to a Discoverer Folder (Doc ID 282249.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Discoverer - Version 4.1.48.08 to 11.1.1.4.0 [Release 4.1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 06-06-2011***
***Checked for relevance on 11-07-2012***
***Checked for relevance on 21-12-2015***

Goal

There will be some circumstances where there is a need to use parameters in Oracle BI Discoverer Administration edition.

For example:

You are trying to display columns from a nested table datatype using custom folder with the following SQL:

select * from table(select emp_desc from employees where ename={Employee Name})



Where {Employee Name} is the parameter for which users will provide a value when running the workbook.

Currently, the Discoverer Administrator does not support parameters in folders. The following steps provide an example of how to workaround this problem.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms