Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: proc connect problem - Oracle 8.0.4.2.2

Re: proc connect problem - Oracle 8.0.4.2.2

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 05 Dec 1999 17:58:25 -0500
Message-ID: <8erl4somtib8rig6g0rbl05lfec7fbtsfi@4ax.com>


A copy of this was sent to aplatts_at_my-deja.com (if that email address didn't require changing) On Sun, 05 Dec 1999 17:41:41 GMT, you wrote:

>I'm trying to connect to a remote Oracle instance (Release 8.0.4.2.2)
>from a proc program (both program and DB run on Solaris 2.6).
>
>The connection actually apears to be fine but the Connect call is
>causing errno to be set to 9. Specifically the
>sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);
>statement generated by the precompiler is causing errno to be set.
>
>Should I worry about this ? The connection does seem to be working
>right.
>

it is fine. errno only applies immediately after a system call such as read, write, open, etc. It is not used for any other sort of calls such as Pro*C. Errno is not used to detect errors from pro*c -- sqlcode is.

>Andrew Platts
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Dec 05 1999 - 16:58:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US