Formatting error

Formatting error

Postby 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
brekhof
 
Posts: 22
Joined: Tue 16 Nov 2004 21:59

Re: Formatting error

Postby alexa » Wed 03 Dec 2014 14:41

We will investigate this issue when developing future product builds.
alexa
Devart Team
 
Posts: 2171
Joined: Fri 24 Jun 2011 14:17

Re: Formatting error

Postby 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/studio/download.html

Thank you for your help in improving dbForge Studio for Oracle.
alexa
Devart Team
 
Posts: 2171
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle