Formatting error

[brekhof]

The statement below is not recognized as valid, it stops before the '.EXTRACT'in the statement claiming that additional ')' have to be supplied. It runs ok however.

Code: Select all

SELECT NVL(rtrim (xmlagg (XMLELEMENT (e, upper(lp.licenseplate)
  || '; ')).EXTRACT ('//text()'), '; ') ,'') AS VALUE
FROM Permit p
INNER JOIN LicensePlate lp
ON p.PermitID          = lp.ParkPermitID
WHERE lp.validfrom_dt <= p.validuntil_dt
AND (lp.validuntil_dt IS NULL
OR lp.validuntil_dt   >= CURRENT_DATE)
AND PermitID           =:permitID

[alexa]

We will investigate this issue when developing future product builds.

[alexa]

We would like to let you know that we have released a new version 3.7 of dbForge Studio for Oracle where the issue you reported is fixed http://www.devart.com/dbforge/oracle/st ... nload.html

Thank you for your help in improving dbForge Studio for Oracle.