Print Thread
Highlighting bug caused by q'[]' literals
#56051 03/04/17 11:33 AM
Joined: Feb 2013
Posts: 46
P
Pazus Offline OP
Member
OP Offline
Member
P
Joined: Feb 2013
Posts: 46
Literals of the form q'[literal]' lead to wrong highlighting


Pavel Kaplya
Re: Highlighting bug caused by q'[]' literals
Pazus #56056 03/06/17 10:13 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
It seems to work fine. Can you let me know your PL/SQL Developer version and a complete example?


Marco Kalter
Allround Automations
Re: Highlighting bug caused by q'[]' literals
Marco Kalter #56058 03/06/17 12:24 PM
Joined: Apr 2007
Posts: 96
Germany
B
Member
Offline
Member
B
Joined: Apr 2007
Posts: 96
Germany
This example is formatted wrong in PSD 12 actual version (and also in PSD 11.0.2 and 10.0.5)

SELECT q'[package.Procedure('val(x)');]' FROM dual

as Reported in this tTicket
https://forums.allroundautomations....mp;Main=13391&Number=51403#Post51403

Re: Highlighting bug caused by q'[]' literals
Benjamin L #56065 03/06/17 07:56 PM
Joined: Dec 2002
Posts: 491
Wellington, NZ
Member
Offline
Member
Joined: Dec 2002
Posts: 491
Wellington, NZ
I agree (and this has been reported a few times).
Code
changing : SELECT q'[package.Procedure('val(x)');]'  FROM dual
      to : SELECT q'[package.Procedure('val(x) ');]' FROM dual

fixes it. note: the space after (x). also an issue with >.


... suck in your lips and frown like a werewolf ...
Re: Highlighting bug caused by q'[]' literals
rbrooker #56069 03/07/17 10:25 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
This is indeed a known error. But is this the case that @Pazus is referring to?


Marco Kalter
Allround Automations
Re: Highlighting bug caused by q'[]' literals
Marco Kalter #56073 03/07/17 09:31 PM
Joined: Dec 2002
Posts: 491
Wellington, NZ
Member
Offline
Member
Joined: Dec 2002
Posts: 491
Wellington, NZ
would depend on what his literal contains ... if it ends with a ) or a > then yes.

@Pazus?


... suck in your lips and frown like a werewolf ...

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.032s Queries: 15 (0.009s) Memory: 2.5169 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 07:26:16 UTC
Valid HTML 5 and Valid CSS