Re: OCI

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).
Received on Thu Sep 14 2000 - 16:15:48 CDT