Passing multiple values to a parameter - works randomly in worksheet
I've been using PL/SQL functions setparam and getparam to pass parameters to Desktop. Recently I had a requirement to pass multiple values to a parameter which worked fine. But lately everytime I make changes( simple change as changing a-b-c to a-b in a calculation) to the folder and re-run the workbook the workbook returns no data.
We're on Discoverer 10g, clearing the local cache works sometimes but not always. The folder validates, te same SQL returns data in SQL Plus or toad. I'm not sure what is the cause behing this random behaviour.
Any pointers is greatly appreciated.
Jean