[WORKAROUND IN PLACE] Retrieving OUT parameters from a stored procedure [message #1694867] |
Fri, 08 May 2015 14:38 |
Eclipse User |
|
|
|
I'm experiencing issues getting data out of an Oracle stored procedure, my chart is rendering with the message "No Results".
The procedure is very simple, there is only a single OUT parameter which returns a decimal value. The Datasource appears to be set up correctly as I can see the correct value returned under "Preview Output Parameters".
Nothing is defined/displayed in the following sections:
- Preview Results
- Output Columns
- Computed Columns
Should there be?
In the Edit Chart wizard, should I be able to do call outputParams["foo"] in the value definition or does have work have to be done first before that statement will work?
BIRT version is 4.4.2.
EDIT: Screenies attached.
EDIT2: As there are no input parameters and only one output parameter, I managed to work around the problem by changing the procedure to a function and calling it as an SQL query. It would still be good to know why I can't get the OUT parameters working though.
[Updated on: Wed, 13 May 2015 11:39] by Moderator Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.02409 seconds