RE: OCI

I like OCI (I'm not a programmer, though) because it gives me the full control over all available oracle features. OCI also makes it easier to use C++ which is very hard to do with PRO*C. And I do not wear a propeller hat or a Red Sox hat, no sir! I wear the good old New York Yankees baseball cap. Jose Conseco is doing just fine, isn't he?

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Thursday, September 14, 2000 7:12 PM To: Multiple recipients of list ORACLE-L Subject: Re:OCI

David,

    OH BOY, have I been down this path before. For some reason some programmers, those with the real propeller hats, love writing for OCI. Why I'll
never figure out. I've written OCI and PRO*C for many a year & I still favor
PRO*C. Anyway, back to the point. Most of those programs probably have not included the SQLCA.H file, so they do no have the SQL COMMUNICATIONS AREA to find out that they have in fact died. Have them include that particular header
& then make periodic checks (like after every SQL statement) to sqlca.sqlcode.
If they find a negative value what happen will be found in sqlca.sqlerrm.sqlerrmc. If the value is a 0 then every thing happen as requested. If it's greater than 0 the no rows were found. Have fun!!

Dick Goulet

____________________Reply Separator____________________
Author: David Turner <turner_at_tellme.com>
Date:       9/14/00 11:35 AM

We have some systems that have flaky connections and it is causing some of our developers' oci apps to hang. How best, aside from getting better connections, would you deal with the hanging. They would like the applications to not just hang but realize that the connection is lost and handle accordingly rather than just hanging.

Thanks, Dave Turner

-- 
Author: David Turner
  INET: turner_at_tellme.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).