Re: Q: ORA-01555

Hi,

This is quite normal because multiple statements can be executed concurrently. Probably somebody else is bothering you with very large update or the rollback segment is
small. So try to find out through v$sqlarea or v$sql_text who is bothering you at the same time
or did you forget a commit in the stored proc and did it in sqlplus maybe by exiting
(implicit commit)
Hope this helps,

Jeroen

Anton Eskov wrote:

> Hi
>
> I am developing a stored procedure in PL/SQL v 2.3.4, Oracle Server release
> 7.3.4.0.0, WinNT. I get ORA-01555 error (Snapshot too old - Rollback Segment
> too old) when quite simple SELECT statement is executed by a stored
> procedure via DBMS_SQL.EXECUTE_AND_FETCH. The very same statement being
> executed directly (say, in SQL*Plus) runs succesfully... No statements
> updating the database are executed before the error occurs.
>
> What could it be?
>
> SY
> Anton
Received on Mon Sep 07 1998 - 09:12:23 CDT