Hi!
Can call store proc populating table , on which report is based,first and then execure report
Report displays data from Table_A, which is populated by SP_BuildTableA.
It was implemented sometime ago and the logic of store proc is quite complex.
Nobody want to change it.
Is there any way, when a user run a report, to call stored procedure SP_BuildTableA.
to populate Table_A and
then the report will select data from Table_A(bassed unique id) using QS SP: SP_GetTableA.
Thank you.
Performance is always an issue but u can cast the return type of a function that creates a plsql table as a sql table making it QS material. See Tom Kyte's "Expert One on One: Oracle" for a good discussion of the technique.