Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Displaying result set of ORACLE stored procedure in Livereport
Stepan_Bouda_(stepan.bouda@syconix.com_(Delete)_45
Hi all,I am seeking for example of ORACLE stored procedure which returns result set to the Live report. We are optimizing Live report displaying categories. The multiple joins of LLATTRDATA mentioned here cause timeout, therefore we decided to optimize it using stored procedures with cursors, but we cannot make it display the results in Live report.Thanks for any hints.
Find more posts tagged with
Comments
Tim_Hunter
can you give an example of how you are returning the result set?Here is an example of outputting from a stored procedure which basically involves a function.
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3045889&objaction=viewI
would suggest looking at a pipelined function for your needs. Also I am interested in seeing what you have done to optimize the return of the LLATTRDATA as I have seen simlilar problems and haven't come up with a good solution for us yet.
