Re[2]: OCI

From: <dgoulet_at_vicr.com>
Date: Fri, 15 Sep 2000 09:30:51 -0400
Message-Id: <10620.117099@fatcity.com>

Dave,

    I don't know if the list is awesome, or just populated by a lot of "war wounded" from the years. At any rate, Yes Jared is doing awesome things just getting us all together. Although it may not seem that way, even old troopers like me learn something new here each day.

Dick Goulet

____________________Reply Separator____________________

Subject: Re: OCI
Author: David Turner <turner_at_tellme.com> Date: 9/14/00 3:12 PM

This list is awesome. Thanks for the help, Dave

P.S. Keep up the great work Jared.

On Thu, Sep 14, 2000 at 04:43:21PM -0400, dgoulet_at_vicr.com wrote:
> 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____________________
> Subject: OCI
> 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: 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).

Received on Fri Sep 15 2000 - 08:30:51 CDT