Calling a report on a temporary global table show no rows on report

[rleiman]

Hi Everyone,

I am using Forms 4.5 and the database is 9i.

In a form we into data into a temporary global table. Also in the form we test to make sure data is written to the table. This works. When we call a report from the form on that same table, the report does not show any rows from that table.

Can you tell us why this is happening and how to resolve it?

We chose the global temporary table so we don't have to include a unique id for each user that will be running the report.

Does calling the report from the form start a new session preventing the report from seeing the data?

Thanks in advance.

Truly,
Emad-ud-deen Richard Leiman

 

[lewisp]

Global temporary tables are session specific. You specify when the temporary data is destroyed at the time of creating the table. If you defined ON COMMIT PRESERVE ROWS then the data will remain for the life of the session.

Of course, if your report starts in a new session it will never be able to see the data....

 

[rleiman]

Hi lewisp,

Yes we did use "ON COMMIT PRESERVE ROWS".

We also thought that it is running in the same session. We started the form running and the form does not do any other connections. It just allows the user to write to the table so the report which is called from a "When-Button-Pressed" trigger.

The form calls a procedure in a package that does the writing to the table. There is also a commit statement inside the package but not in the form.

I think I will also place a commit in the form to see if it makes a diference.

Thanks.

Emad

 

[rleiman]

Hi.

I tried placing the commit statement in the form as well but the report does not print any rows.

Also on the report, there is no where clause so all rows should be printing.

Is there something else we are missing?

By the way, it does print if we use a regular table. We do want to avoid this so the session is unique to each person who runs the report at the same time.

Thanks.

Emad