APEX

Hi Folks

I'm calling a report stored in APEX (Shared Components Report Query & Layout) many times using a loop in a process on my page.

At each iteration of the loop I am updating the value of a hidden text item on the page which is the one and only parameter of the report.

I update the hidden text item using APEX_UTIL.SET_SESSION_STATE.

The first time I call the report from the process it works perfectly, the .pdf file is produced and stored in a BLOB column in the database.

The problem is that all subsequent iterations of the loop to produce the report result in a report .pdf being generated and stored but with no database values. As if the hidden text item value was NULL or not valid for the query.

I know there is no problem with the report queries or the parameter values I am using. I have tested this by forcing the initial value set by APEX_UTIL.SET_SESSION_STATE to be the next record I would have supplied in the loop. Again, the first report is generated with data and all subsequent reports get generated with no data.

It appears that whilst I can use APEX_UTIL.SET_SESSION_STATE to loop through and update the value of the hidden text item my report refers to for it's parameter, the report process only seems to recognise the first iteration and none of the subsequent ones.

Can anyone shed any light on this or offer any suggestions?

Many thanks

Dogfighter.