Re: Inband and Outband Net8 question

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" <ORACLE-L_at_fatcity.com> 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: SinardyXing_at_bkgcomsvc.com
>
> 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: ListGuru_at_fatcity.com (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: MGogala_at_oxhp.com
>
> 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: ListGuru_at_fatcity.com (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: anjo_at_oraperf.com

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: ListGuru_at_fatcity.com (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).