Formatting error

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
brekhof
Posts: 22
Joined: Tue 16 Nov 2004 21:59

Formatting error

Post by brekhof » Wed 03 Dec 2014 13:14

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
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Formatting error

Post by alexa » Wed 03 Dec 2014 14:41

We will investigate this issue when developing future product builds.

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Formatting error

Post by alexa » Fri 30 Jan 2015 14:15

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.

Post Reply