Aliasing columns using an Oracle function

The Optiva JavaScript parses the XML. This is based on the values that are specified in every tab of the Lookup Set form. This data is sent to the web client as XML.

XML nodes cannot have parentheses, spaces, etc. as the name of a node; otherwise, they will not be correctly parsed by XML. If an Oracle function is used, then a parenthesis is added. This example uses the NVL function.


NVL{U.DESCRIPTION, ' '}

The solution is to put an alias for these columns after the function. The XML code uses the alias for parsing.


NVL{U.DESCRIPTION, ' '} "OWNER"