Home » Developer & Programmer » JDeveloper, Java & XML » xml parsing failed,, xdk is installed
icon8.gif  xml parsing failed,, xdk is installed [message #186496] Tue, 08 August 2006 04:18 Go to next message
powerspike
Messages: 1
Registered: August 2006
Junior Member
hi
what am i doing wrong here? Mad

oracle 10.2.0.1
AL32UTF8 charset.
trying to generate an xml using xdk

running this

SELECT XMLELEMENT("date", sysdate) FROM dual

expecting this

<date>2005-10-25</date>

getting this

ORA-31011: XML parsing failed

tried this:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY'

result: session altered
tried re-running select query, but same result.
Mad

dbms_xmlgen,xmlagg and other commands run fine. (indicating xdk is present?)

i need to do this so that i can use special inline formatting such as this:
<sa>
..
<object class="asdad" name="asd">
<attribute name="as">
<string>asd</string>
</attribute>
..
</object>
<object>
..
..
</object>
</sa>

setformattype doesnt help in xmlgen since such format (<object class="asd" name="sad">) doesnt seem to be possible.

YELP!

is there a workaround possible without using xmlelement? what am i doing wrong in xmlelement??
Mad
Re: xml parsing failed,, xdk is installed [message #186554 is a reply to message #186496] Tue, 08 August 2006 08:22 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You're not doing anything wrong that I can spot.

SQL> select XMLELEMENT("date", sysdate) from dual;

XMLELEMENT("DATE",SYSDATE)
---------------------------------------------------
<date>01-SEP-06</date>
Previous Topic: ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier
Next Topic: Connecting Java bean to Oracle?
Goto Forum:
  


Current Time: Sat Dec 03 17:49:36 CST 2016

Total time taken to generate the page: 0.07283 seconds