Passing multiple parameters to BIP (BI Publisher) report using web service
Hi Everyone.
I have set up a BI Publisher web service and I can get this to produce a single report based on a single primary key parameter being sent in the SOAP Envelope.
If I want to send a string of primary keys in the single report parameter, could someone please point me in the right direction as to how to do this.
I have the report set up in BIP with the parameter data type set as String
and the "Text field contains comma-separated values" option selected (ticked).
When I edit my SOAP command to say...
<item>
<name>P_INVOICE_ID</name>
<multiValuesAllowed>true</multiValuesAllowed>
<values>
<item>16946,18421,17676;</item>
</values>
</item>
it fails with a message "oracle.apps.xdo.servlet.scheduler.ProcessingException: oracle.apps.xdo.XDOException: ORA-00933: SQL command not properly ended"
I have tried leaving the ';' off the end of the string.
I have tried ending with a ','
Neither option seems to work.
Anyone in the APEX community done this?
Many thanks
Simon