My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2022

Applies to:

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


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:

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.


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

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