Register now or log in to join your professional community.
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
Invalid character issue need to put correct XML tag
The NLS_NUMERIC_CHARACTERS option specifies the decimal marker (of decimal separator) and thousands group marker (of group separator) for the session.
The NLS_NUMERIC_CHARACTERS is a result of the NLS_LANG setting.
The decimal character and the group separator must be two different single-byte characters, and cannot be a numeric value or any of the following characters: plus sign (“+”), less-than sign (“<”), minus sign or hyphen (“-” ), or greater-than sign (“>”).
If the decimal character is not a period (.), you must use single quotation marks to enclose all number values that appear in expressions in your SQL statements.
NLS_NUMERIC_CHARACTERS affects the display of numeric data.
Within a session, you can dynamically modify the value by using the SQL statement
Hi,
May be any aplha numerical values may be stopping the tag from execution from your query results.For the fileds having alpha numerical o/p use the replace command and try generating the xml File.
e.g:
SELECT Replace(''.'', ' ', a.column) from a
