Help with continue statement

663394

I am facing problem using the continue statement, here is a mock-up

-----
DECLARE
x NUMBER := 0;
BEGIN
LOOP -- After CONTINUE statement, control resumes here
DBMS_OUTPUT.PUT_LINE ('Inside loop: x = ' || TO_CHAR(x));
x := x + 1;

IF x < 3 THEN
CONTINUE;
END IF;

DBMS_OUTPUT.PUT_LINE
('Inside loop, after CONTINUE: x = ' || TO_CHAR(x));

EXIT WHEN x = 5;
END LOOP;

DBMS_OUTPUT.PUT_LINE (' After loop: x = ' || TO_CHAR(x));
END;
-----
when I execute this in in Quest script runner, I get an error message saying 'Identifier CONTINUE must be declared'

21205

It's probably a problem with your tool. Assuming you're on Oracle 11gR1, run the script in SQL*Plus and it will work.

BluShadow

Maybe a quick search on the internet has the answer...

http://dba.ipbhost.com/index.php?showtopic=8736

21205

It's probably a problem with your tool. Assuming you're on Oracle 11gR1, run the script in SQL*Plus and it will work.

SomeoneElse

The CONTINUE statement is a new feature of 11g.

You didn't tell us what version you are using.

663394

Thanks I actaully stumbled on that site after posting the question.Any way as 'someone else' pointed continue is not supported in my version (10 g). Thanks a lot everyone for your time.