Problems with rollback/opened cursors (post)

From: Carlos Netto <Carlos.Netto_at_ax.apc.org>
Date: Fri, 12 Aug 94 22:38:00 -0300
Message-ID: <2aa.550.846%mpcbbs_at_ax.apc.org>

Hi, all:

I'm running a PRO*C program like this:

  set transaction use rollback ...; <------------- (C)   open cursor;
  while ( 1 )
    {

       fetch ...                <----------------- (B)
       if ( condition )
          rollback;             <----------------- (A)

    }
  close cursor;   

When I rollback the transaction (A), the next fetch (B) fail with message "cursor must be open before fetch". Rollback seems to be closing the cursor. But, when I remove the "set transaction use rollback..." (C) everythink works!

Oracle version: 7.0.16
OS : HP/UX

It seems to be a Oracle Bug, but... any answer is wellcome!

Thanks,

---

| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ax.apc.org |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |

|---------------------------------------------------------------------------|


|  Softex 2000 member             | Brazil, Sao Paulo state, Campinas city  |


=============================================================================

... If you're not the lead dog, the view can be very interesting! - W. Wi

• Evaluation copy of Silver Xpress. Day # 49 --- via Silver Xpress V4.01P [NR]

  ---

Internet: Carlos.Netto_at_ax.apc.org (Carlos Netto) This message was processed by RAuucp from Merlin Systems Inc.

---

Received on Sat Aug 13 1994 - 03:38:00 CEST