Re: rollback chocking up ... why? cursor to blame??

From: Chris Eastwood <c.undieseastwood_at_gu.edu.au>
Date: Wed, 23 Jun 1999 01:33:56 GMT
Message-ID: <7kpdi7$gvf$1_at_kraken.itc.gu.edu.au>

HiYa

>You don't have the error message so I'll guess that it is 1555 snapshot too
> old.

pim pom pim pom

>If so, you are causing it yourself by committing. Also, some of your
>assumptions above are incorrect.

Ok ... interesting ....

I understand the error, I didn't think that there was any reference back to the cursor, but that was wrong.

I am now making a temp table "unrecoverable" from the subquery as a first step and then inserting into AAA from that with the cursor.

thanks for the information :-)

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer email ua.ude.ug.xobliam_at_doowtsae.c Motorcyclist and dingbat

please remove undies for reply

---

Ohhh ... you work all day, slave over a hot stove all night  yet you *still* have time for sadomasochism ... how do you do it? A little man hurts me.
<ding>

    Oh Mister Mean ... Oh Mister Mean
    15 Minutes with him and you'll be blue and green     Studded belts and leather whips
    Bondage trousers on his hips
    Wack and punish as you dust with Mister Mean   Ohhhh he whips me around the house in minutes ... lets get cracking ... Received on Wed Jun 23 1999 - 03:33:56 CEST