The error is not in FOR LOOP. The error would be in the cursor definition. Try to execute the SELECT stmt in the cursor seperately to see it has any errors.

-Suri.

-----Original Message-----
From: Harmon, David [mailto:David.[Email Address Removed] Friday, February 28, 2003 10:54 AM
To: LazyDBA.com Discussion
Subject: 'Invalid number' in cursor loop


Hi all.

Anyone ever seen an ORA-01722 - (invalid number) pointing to the 'FOR' statement of a cursor loop?

The line number the error points to just says:

For row1 in c1 loop

Strange?

TIA.

David

--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page