Re: ora err 1555

From: Frank <frankbo_at_interaccess.nl>
Date: 2000/09/21
Message-ID: <8qd34f$ljv$1@porthos.nl.uu.net>#1/1

Nope, just for the one transaction (that would be oracle, not human transaction).
Re-issue it.

BTW, are you closing cursors, or doing commits over open cursors? Common cause for 1555's with procedural languages.

--
Frank
Richard Leffingwell <rdlpip_at_mindspring.com> schreef in berichtnieuws
39c92e9a.14554091_at_news.mindspring.com...


> Hello,

>

> I'm running a C program with embedded SQL that is constantly bombing

> out with the error message ora-1555, refering that the 'snapshot is

> too old, rollback segment too small'.  The manual says to use a larger

> rollback segment.  Is this all I can do?  And if I do get a larger

> segment from my dba, how do I specify to use it.  The manual says to

> use the SET TRANSACTION statement, but where do I put this statement.

> If I put it at the begining of my procedure with my SQL calls, will

> this directive be valid for all the following SQL statements.  Any

> advice would be much appreciated.

>

> Thanks,

> -rleffin

>

Received on Thu Sep 21 2000 - 00:00:00 CDT