Leo -
Did you ever work out this problem? We just received ESQL/C and OnLine 7.10
with the bundled XA libraries. We are planning on doing the same thing, with
/T vers.4.2.2, and are concerned about the ability to use strored procs.
Can you or anyone else elaborate on using OnLine 7.10 as an XA-compiant RM?
TIA
Jon
At 05:23 PM 3/29/95 GMT, Leo Tsesmelis wrote:
>Anyone running ONLINE 6.0 in a TUXEDO 4.2.2 system as an XA-compliant
>resource manager? If yes, here is our problem:
>
>We've got a simple Tuxedo service (in SQL/C of course) that executes a stored
>procedure to insert a row in a table and obtain the primary key's serial
>value. The first time the service is called, everything is fine. But, any
>subsequent time, error -267: The cursor has been previously released and is
>unavailable' is returned.
>
>Now, the XA standard 'says' that db resources are released at the end of the
>service. So what's the right way to call a stored procedured
>from within an XA-compliant server?
>
>Cheers, Leo
>
>
==================================================================
Jon Vemo Internet: jvemo@cyberspace.com
Bothell, WA USA
------------------------------------------------------------------
Watch out for road-kill on the information superhighway....SPLAT!!
==================================================================