Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: ORA-01555
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 - 00:00:00 CDT