Skip to Main Content

SQL Developer

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Parser 19.1 can not parse the correct code, but the previous 18.4 one could { i_p => case } Problem

2907631Apr 13 2019 — edited Apr 17 2019

The code below is compiled and executed in Oracle Database 18c (18.4), but the parser (19.1.0.094) cannot parse it,

but the previous (18.4.0.376) one could. Is this some kind of problem with parsing in 19.1 ?

declare

procedure p(i_p in number) is

begin

dbms\_output.put\_line(i\_p);

end;

begin

p(i_p => case

         when 1 = 1 then

          case

            when 2 > 0 then

             1

            else

             0

          end

         else

          0

       end);

end;

Not Ok with 19.1:

parser_syntax_error_19.1_01.png

Ok with 18.4:

parser_syntax_error_18.4_01.png

This post has been answered by Vadim Tropashko-Oracle on Apr 15 2019
Jump to Answer

Comments

Post Details

Added on Apr 13 2019
5 comments
376 views