Home » SQL & PL/SQL » SQL & PL/SQL » temporary tables problem
temporary tables problem [message #228612] Tue, 03 April 2007 08:19 Go to next message
whiteadi
Messages: 1
Registered: April 2007
Location: Timisoara
Junior Member

Hi,

I have a c++ class, from it I select in a transaction data from a temporary table.

So I have an instance of the class, gets data, comit or rollback transaction.

New instance does not get the selected data for same input data. If I close and open

the program again works for first time but only first.

Regards,
Adrian

CREATE GLOBAL TEMPORARY TABLE ... ON COMMIT DELETE ROWS
Re: temporary tables problem [message #228614 is a reply to message #228612] Tue, 03 April 2007 08:26 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session

source
Previous Topic: to get the round off value of a float value
Next Topic: Independent autonomous transactions
Goto Forum:
  


Current Time: Thu Dec 08 16:32:58 CST 2016

Total time taken to generate the page: 0.05381 seconds