Home » Developer & Programmer » Reports & Discoverer » Calculations using Functions
Calculations using Functions [message #324325] Mon, 02 June 2008 00:42
Messages: 4
Registered: June 2008
Junior Member
Instead of having a parameter that allows a user to select multiple values that would be used for an IN predicate condition, I am trying to create a calculation instead and then use it in the condition.

The calculation will call a PL/SQL function and get the values. Then a condition will apply the IN predicate on this calculation to an existing column.

I have created a PL/SQL function that I have registered with Discoverer Plus. The problem is the function is returning a string of comma separated values e.g. 1454,5768768,1354

Is there a way I can get the Discoverer Calculation to treat it as a collection/array of numbers?
Previous Topic: Between page trigger in Reports
Next Topic: Flex field in Oracle Reports
Goto Forum:

Current Time: Fri Aug 18 13:26:18 CDT 2017

Total time taken to generate the page: 1.00056 seconds