Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 10g Release 2 Discoverer - eul_trigger$post_save_document

user1832363Jul 2 2020 — edited Jul 17 2020

Hi,

I'm attempting to extract Report SQL from Discoverer via eul_trigger$post_save_document, as seen here:

https://docs.oracle.com/cd/B25016_08/doc/dl/bi/B13916_04/appendix_b.htm#sthref2416

However, there is a VARCHAR size limit to the SQLSegment parameter, and the query sizes I'm dealing with are much larger. I've modified this to a LONG and CLOB which has produced some results as opposed to none, but only the back end of the final worksheet of the workbook's SQL appears in the my_sql table.

Can anyone help please?

Kind Regards,

Mark

This post has been answered by Aliaksandr Paulik on Jul 6 2020

Jump to Answer

Added on Jul 2 2020

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

4 comments

314 views