Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLSQL "Continue" statement not recognized

PaulPJul 15 2009 — edited Jul 15 2009
A PLSQL process is not recognizing the PLSQL "continue" statement which is suppose to break only the current loop.
The error message I get is

1 error has occurred
ORA-06550: line 71, column 2: PLS-00201: identifier 'CONTINUE' must be declared ORA-06550: line 71, column 2: PL/SQL: Statement ignored

here is my code
e.g.
FOR i in 1..htmldb_application.g_f10.count
LOOP
begin
select distinct CON_NAME,CON_EMAIL
into v_student_name,v_to
from "CONTACT",
"STUDENT",
"BOOKING"
where CON_ID=STU_CONTACT_ID
and STU_ID=BOOK_STUDENT_ID
and BOOK_EVENT_ID=:P27_COURSE_DESCRIPTION
and CON_ID=htmldb_application.g_f10(i);
exception
when no_data_found then
continue;
end;
.............
............
END LOOP;
....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2009
Added on Jul 15 2009
5 comments
3,628 views