Re: open "cursors" on the server

From: newhorizon <mehmeteser_at_gmail.com>
Date: Wed, 20 Aug 2008 02:50:21 -0700 (PDT)
Message-ID: <c7247b3c-6409-44fb-a15c-dcfdb692c9a4@j22g2000hsf.googlegroups.com>

do you get an ORA-01555 error even if the you use a result set ? I believe the question is how does a result set work for Oracle.

Dose it get all the queried data from the server and store it locally make some modifications and upload the data. or
Does it act like a cursor and never get the whole data from the server but fetch it like a cursor.

how does the result set work ? Received on Wed Aug 20 2008 - 04:50:21 CDT

This message: [ Message body ]
Next message: William Robertson: "Re: Passing queries from procedure call in a script ... possible?"
Previous message: newhorizon: "Re: pmon and alert.log database up timing issue"
In reply to: Vladimir M. Zakharychev: "Re: open "cursors" on the server"
Next in thread: Vladimir M. Zakharychev: "Re: open "cursors" on the server"
Reply: Vladimir M. Zakharychev: "Re: open "cursors" on the server"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message