I have I command_1 tht returns data and simultaneously inserting data to global temporary table (GTT).
I need to execute command_1 first (get data, and put data to GTT) and next execute command_2 that will return data from GTT. I have to do this on one page.

Can I anyway set priority which command should execute first, wait for finish, and execute second command?

Works fine if I have two subraports. One with command1 and second with command2. First subraport gets data and inser new data in GTT via procedure with autonomical transaction. Second subraport takes data from GTT. But how get the same on one raport?

I have a report for same companies. First command (procedure) return sth like this for two companies:

|  NUMBER  |  COMPANY  |  DAY  |  MONTH  |  YEAR  |  COMPANY  |  DAY  |  MONTH  |  YEAR  |

and second command return exactly this:

|  NUMBER  |  COMPANY  |  DAY  |  MONTH  |  YEAR  |

Command 1 looks like:

select 
  a.number,
  a.company, a.day, a.month, a.year,
  b.company, b.day, b.month, b.year,
from table( REP_PCK.rep(sysdate, 'IBM') ) a
join table( REP_PCK.rep(sysdate, 'SONY') ) b
on (a.number = b.number)

Command 2 looks like:

select number, 'SUM FOR ALL' company, day, month, year
from rap_gtt

I can not do this like this:

select 
  a.number,
  a.company, a.day, a.month, a.year,
  b.company, b.day, b.month, b.year,
  c.company, c.day, c.month, c.year,
from table( REP_PCK.rep(sysdate, 'IBM') ) a
join table( REP_PCK.rep(sysdate, 'SONY') ) b on (a.number = b.number)
join rap_gtt c on (a.number = c.number)

cause I will get no data or data that was in rap_gtt before I execute query.
Ok, I can use two queries but how to set that command 1 should execute first, command 2 has to wait for command 1 and after this just execute.


Edited by rozpalacz - 19 Jan 2011 at 9:09pm

I use second command to get summary of all companies.
Are You using Oracle? I can send You an example what I want to get, why and how - PL\SQL procedure, rpt file and example tables.

I just want to know, how execute command_1 (query) that will return data for each company, wait for finish, and next execute command_2 (query) to get summary of all companies. Thats all.

Make a single command that is an anonymous PL/SQL block that will run the first query and then the second query.  That way you know that the first part will always run first.