Forums Active Threads
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
Pazus
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,239
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,239
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
Benjamin L Offline
Member
Offline
Benjamin L
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
rbrooker Offline
Member
Offline
rbrooker
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,239
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,239
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
rbrooker Offline
Member
Offline
rbrooker
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
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.044s Queries: 15 (0.019s) Memory: 2.5182 MB (Peak: 3.0407 MB) Data Comp: Off Server Time: 2024-06-26 10:00:50 UTC
Valid HTML 5 and Valid CSS