PL/SQL - Nested if else if syntax

Question

I'm developing a trigger in PL/SQL.

It has this building structure:

if a = 1 then
    if b = 1 then
        (some code here);
    else if b=2 then
        (some code here);
    else if b=3 then
        (some code here);
    else b=4
        (some code here);
    end if;
else if a=2 then
    if b=1 then
        (some code here);
    else if b=2 then
        (some code here);
    else if b=3 then
        (some code here);
    else b=4
        (some code here);
    end if;
else
    if b=1 then
        (some code here);
    else if b=2 then
        (some code here);
    else if b=3 then
        (some code here);
    else b=4
        (some code here);
    end if;
end if;

However, it seems like the last else statement(a=3) is not well defined, cause the compiler says to me that expects a " ( "

Can i have a help in here? Thank you all

the issue stems from else if which should be elsif. Need to be fixed for every occurence within your code. — Barbaros Özhan
– Barbaros Özhan, Commented Sep 19, 2022 at 8:55

Littlefoot · Accepted Answer · 2022-09-19 08:56:12Z

3

That's because you probably meant to say ELSIF, not ELSE IF (not only at the last place you mentioned, but everywhere).

Something like this:

if a = 1 then
    if b = 1 then
        (some code here);
    elsif b=2 then
        (some code here);
    elsif b=3 then
        (some code here);
    elsif b=4
        (some code here);
    end if;
elsif a=2 then
    if b=1 then ...

answered Sep 19, 2022 at 8:56

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nhoj Anec Over a year ago

Somehow solved that error, however gives me an error at the end trigger clause, expecting semicolon, parenthesis, full stop... If i add another end if at the end, the error...poof, gone, but i don't think that makes sense, what does that end if "closes"?

Littlefoot Over a year ago

Can't tell, unless you post code you currently have.

Nhoj Anec Over a year ago

solve me the error, so this question has to be marked as solved, thank you

Littlefoot Over a year ago

I'm glad you made it work, you're welcome.

Collectives™ on Stack Overflow

PL/SQL - Nested if else if syntax

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related