Marco Kalter Administrator Staff member Mar 6, 2017 #1 It seems to work fine. Can you let me know your PL/SQL Developer version and a complete example?
B Benjamin L Member² Mar 6, 2017 #1 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 tTickethttps://forums.allroundautomations....bb=showflat&Main=13391&Number=51403#Post51403
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 tTickethttps://forums.allroundautomations....bb=showflat&Main=13391&Number=51403#Post51403
rbrooker Member³ Mar 6, 2017 #1 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 >.
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 >.
Marco Kalter Administrator Staff member Mar 7, 2017 #1 This is indeed a known error. But is this the case that @Pazus is referring to?
rbrooker Member³ Mar 7, 2017 #1 would depend on what his literal contains ... if it ends with a ) or a > then yes. @Pazus?