Re: Reporting with dynamic sql

G Quesnel wrote:
> BTW / just a little side note - you are not using TEMP tables. You are
> creating regular tables, and that is why multiple sessions can see data
> from other sessions.
> A temporary table would be created with something like ...
> Create global temporary table T1 (c1 number ....) on commit delete rows;

I tried it. I just added global temporary to the 3 create table query to see how it went. Results are erratic. I will get data once in a while, but most of the time, it's just empty. I tried with "ON COMMIT DELETE ROWS", "ON COMMIT PRESERVE ROWS", and without either clause.

Results are constant with the regular CREATE TABLE, meaning I get my data.

Denis Received on Thu Aug 17 2006 - 10:56:02 CDT