error PLS-00201:

[SAMEER CHAUDHARI]

hi friends,

i hv my plsql block in that i use goto statement in that i got the error above mesion.

my plsql block is

 
create procedure xyz(abc in number)
as
 
begin
 
IF abc = 0 THEN
GOTO LOOP_1;
END IF;
 
<<LOOP_1>>
 
<select statment>
 
end;
 
 

but in this he give me error that

PLS-00201: identifier 'LOOP_1' must be declared

but for lable there is no declaration so plz give me some solution on this

[Dave44]

well hopefully you can find the issue by referencing this:

DECLARE
       v_num1     NUMBER := 2;
       v_num2     NUMBER := 3;
  BEGIN
       IF v_num1 > v_num2
       THEN
            GOTO loc_1;
       ELSE
            GOTO loc_2;
       END IF;
 
       <<loc_1>>
       DBMS_OUTPUT.put_line('loc_1');
 
       <<loc_2>>
       DBMS_OUTPUT.put_line('loc_2');
  END;
  /

loc_2

PL/SQL procedure successfully completed.

remember that with goto the tag for where it should go to has to be in scope... which limits its usefullness in many ways.

[amitpatel66]

hi friends,

i hv my plsql block in that i use goto statement in that i got the error above mesion.

my plsql block is

 
create procedure xyz(abc in number)
as
 
begin
 
IF abc = 0 THEN
GOTO LOOP_1;
END IF;
 
<<LOOP_1>>
 
<select statment>
 
end;
 
 

but in this he give me error that

PLS-00201: identifier 'LOOP_1' must be declared

but for lable there is no declaration so plz give me some solution on this

Hi SAMEER CHAUDHARI,

Welcome To TSDN!!

Please make sure you follow POSTING GUIDELINES every time you POST in this forum.

Thanks
MODERATOR