plsql - PLS-00103: Encountered the symbol “CREATE” -

plsql - PLS-00103: Encountered the symbol “CREATE” -

its showing error in 27 line create or replace function buffalo

declare random_number number(4); user_number number(4); cow number(1); buffaloes number(1):=0; begin random_number:=uniquetest(random_number); /*random_number:=dbms_random.value(1000,9999);*/ dbms_output.put_line(random_number); user_number:=&user_number; while(user_number!=random_number) loop buffaloes:=buffalo(user_number,random_number); dbms_output.put_line('0'||'c'||buffaloes||'b'); buffaloes:=0; user_number:=0; user_number:=&user_number; end loop; end; /*error in line */ create or replace function buffalo (user_number in number,random_number in number) homecoming number user_comparision number(1); random_comparision number(1); buffaloes number(1); user_number1 number(4):=user_number; random_number1 number(4):=random_number; begin while(user_number!=random_number) loop user_comparision:=user_number1 mod 10; random_comparision:=random_number1 mod 10; user_number1:=user_number1/10; random_number1:=random_number1/10; if(user_comparision = random_comparision) buffaloes:=buffaloes+1; end if; end loop; homecoming buffaloes; end;/

it showing error in create statement. can help me in solving error.

tell how solve create statement error.

it showing error in create statement. can help me in solving error.

tell how solve create statement error.

you should create 2 scripts of it. you're starting off anonymous block, calling function buffalo, while hasn't been created yet.

both anonymous block , function seem creating infinite loop way, i'm not sure you're trying accomplish here.. without knowing background of problem it's impossible give solution.

plsql