| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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____________________Subject: OCI
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 - 15:43:21 CDT
 |
 |