Home » Developer & Programmer » Reports & Discoverer » Calculations using Functions
Calculations using Functions [message #324325] Mon, 02 June 2008 00:42
mcgirr
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.

e.g.
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: Wed Dec 07 16:31:50 CST 2016

Total time taken to generate the page: 0.05262 seconds