open "cursors" on the server
Date: Tue, 19 Aug 2008 09:21:43 +0200
Message-ID: <6gvak6Fhr9bgU1@mid.dfncis.de>
Hi,
i need something to know:
if i have a java programm and send some sql statements via jdbc to the
oracle server, then i will store the resultset in a resultset variable
(without getting any data of a row from the server).
now its possible, that eg 10 hours later, the programm use the
resultsetobject and begin to compute the data (so with .nextrecord the data
of the rows are needed from the server).
(You can compare this szenario with open a cursor but getting the data of
this cursor could be done 10 hours later.)
What data may i get? will i get the data, that was on the server, when i
send the sql statement? or will i get the data, when i compute the
resultset?
Remember: the data on the server can changed?
How do oracle manage this?
Greets
Micha Received on Tue Aug 19 2008 - 02:21:43 CDT