OraFAQ Forum: JDeveloper, Java & XML » xml parsing failed,, xdk is installed

Home » Developer & Programmer » JDeveloper, Java & XML » xml parsing failed,, xdk is installed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

xml parsing failed,, xdk is installed [message #186496]

Tue, 08 August 2006 04:18

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

Report message to a moderator

Re: xml parsing failed,, xdk is installed [message #186554 is a reply to message #186496]

Tue, 08 August 2006 08:22

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>

Report message to a moderator

Previous Topic:	ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier
Next Topic:	Connecting Java bean to Oracle?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 00:32:47 CST 2024