NetNews Usenet Archive 1992 #27/NN_1992_27.iso/spool/comp/database/oracle/2275

Internet Message Format | 1992-11-23 | 902 b

Path: sparky!uunet!OWGVM0.VNET.IBM.COM
From: [e-mail] (Alan Beal)
Message-ID: <[e-mail]>
Date: Mon, 23 Nov 92 15:09:41 EST
Newsgroups: comp.databases.oracle
Subject: more XA problems
Organization: Federal Systems Company (IBM)
Lines: 12

Using the 7.0.9 beta version of Oracle XA, we have experienced many
problems with invalid cursors using Encina.  We eliminated many
by specifiying RELEASE_CURSOR=YES during the Pro*C precompile.  Now
we experience invalid cursors after we get a not found during an
update or delete.  We already changed our code that used SELECT INTO
to use explicit cursors, and now we are doing the same with the
update and delete statements.  As anyone experience similiar problems
and are there any general rules of thumb when working in this
environment?

Alan Beal         [e-mail]
                  [phone]