4

Possible Duplicate:
‘CONTINUE’ keyword in Oracle 10g PL/SQL

I am Using Oracle 9i and I want to use continue statement or its equivalent in PL/SQL. So is there any keyword called "continue" in oracle 9i. If not, please let me know the solution for this.

Community
  • 1
  • 1
i2ijeya
  • 15,952
  • 18
  • 63
  • 72
  • 1
    It seems this questions is duplicate of http://stackoverflow.com/questions/177752/continue-keyword-in-oracle-10g-pl-sql – Crozin May 21 '10 at 15:09

1 Answers1

8

The CONTINUE statement was added in Oracle 11G, it is not available in prior versions. A solution would be to use GOTO:

loop
   if something then
      goto continue_label;
   end if;
   ...
   <<continue_label>> null;
end loop;
Tony Andrews
  • 129,880
  • 21
  • 220
  • 259