Nope, This will just cancel the current query *AFTER* a fetch. What you describe means that you need to run with non-blocking oci.
Anjo. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 3:44 PM > Out of band breaks are pimarily used to cancel a query or transaction. In > the new OCCI, out of band breaks corresponds to the "cancel" method in the > ResultSet class or "terminateStatement" in the Connection class. I > sort of hate this stuff. Those things used to be called ocan and obreak > and OCCI was OCI and it worked just as fine if not better. OCCI is one > enormous monster that I have neither will nor desire to use. The purpose > of these two statements was to break whatever your session was doing and > it was implemented like a network version of signal delivery, much like > ctrl-C. > > -----Original Message----- > Sent: Tuesday, March 18, 2003 1:49 AM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > I have question about "Inband break", please help me understand this > > Oracle said: > > There are 2 types of breaks: > - Inband breaks: are transmitted as part of regular data traffic using the > normal protocol read and write functions. These breaks are symply queued. > - Outband breaks: are faster as it is send during urgent data messages. > These messages cause signals and take a lot of load of the server. > > These are my questions: > > What is the purpose of Inband break? > when we use it during our day to day activities? > is this break trigger automatically (something like "end" of some activity)? > > > Thanks, > > Sinardy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sinardy Xing > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).