If you are unable to create a new account, please email support@bspsoftware.com

 

Call store proc populating table , on which report is based,first and then execu

Started by NetSpace, 15 Aug 2006 11:35:24 AM

Previous topic - Next topic

NetSpace

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.

rmark17

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.