My Oracle Support Banner

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

Last updated on JANUARY 23, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.