Print Thread
CASE statement - parser bug in Progam Window
#48941 04/28/14 07:04 AM
Joined: Aug 2003
Posts: 54
EE
M
marek Offline OP
Member
OP Offline
Member
M
Joined: Aug 2003
Posts: 54
EE
Beautifier gives "Unable to perform operation due to errors in source code", code folding does not work as well
Code
CREATE OR REPLACE PROCEDURE test_proc(p OUT NUMBER) IS
BEGIN
  p := - CASE
         WHEN 1 = 1 THEN
          1
         ELSE
          0
       END;
END;

Re: CASE statement - parser bug in Progam Window
marek #48944 04/28/14 10:33 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Apparently the minus sign before the CASE statement confuses the parser. We'll fix it.


Marco Kalter
Allround Automations
Re: CASE statement - parser bug in Progam Window
Marco Kalter #48957 04/30/14 09:55 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
I think it is related to a bug reported in the post Bug: Refactoring - Rename item does not work when prefixed with a minus.
In this post it is also a minus sign that causes problems. The posts is from 2010, so a fix soon would be nice ...

Re: CASE statement - parser bug in Progam Window
Marco Kalter #64528 03/28/23 05:26 AM
Joined: Aug 2003
Posts: 54
EE
M
marek Offline OP
Member
OP Offline
Member
M
Joined: Aug 2003
Posts: 54
EE
The bug is still there

PL/SQL Developer
Version 15.0.3.2059 (64 bit)
01.145995 - 1 user license
Service Contract: 01.01.2024
Style: Windows 11 Dark
Windows 10 Build 19044
en-US(1033)/English (United States)

Physical memory : 16 654 944 kB (5 705 516 available)
Paging file : 23 208 544 kB (7 890 724 available)
Virtual memory : 137 438 953 344 kB (137 366 427 268 available)


Regards,
Marek

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.040s Queries: 14 (0.015s) Memory: 2.5128 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-17 10:41:27 UTC
Valid HTML 5 and Valid CSS