My Oracle Support Banner

ORA-01001 Raised in 10g and Higher After Upgrade from 9i (Doc ID 1075385.1)

Last updated on JULY 17, 2017

Applies to:

PL/SQL - Version: to - Release: 10.1 to 11.2
Information in this document applies to any platform.


PL/SQL block which ran fine in 9i now fails in 10g.  Removing exception handling we are able to determine that the error ORA-01001 is raised within a cursor for .. loop.

set serveroutput on

 cursor my_cur is select * from dual;
 i number := 1;
 FOR my_rec in my_cur LOOP
  dbms_output.put_line('i ' || i );
  FETCH my_cur INTO my_rec;
  i := i+1;

ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at line 7


Upgrade Oracle from using an earlier version [up to 9.2] PL/SQL (to any higher version).


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.