| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
