Home » Developer & Programmer » JDeveloper, Java & XML » ORA-00911: invalid character when using X-path in XSQL
icon10.gif  ORA-00911: invalid character when using X-path in XSQL [message #216784] Tue, 30 January 2007 06:36
truegilly
Messages: 3
Registered: November 2006
Location: leicester UK
Junior Member
Hi Everybody,

I have a problem with an error that keeps popping up when I try and extract data from my XML type.

I have the following simple statement...

SELECT SELECT (srt.DDDD(
		'LE29BH',
		srt.PPPP(
		extract(s.OBJECT_VALUE,
		'/shipDetails/shipXPosition/text()').getnumberVal(),
		extract(s.OBJECT_VALUE,
		'/shipDetails/shipYPosition/text()').getnumberVal()
		),
		s.OBJECT_VALUE.extract('/shipDetails/shipSpeed/text()').getnumberVal(),8).YYYY(
		srt.DDDD('LE29BH',srt.PPPP(20,6),
		s.OBJECT_VALUE.extract('/shipDetails/shipBearing/text()').getnumberVal(),8)) as Result)) 
		FROM Ship s;


It works fine in ISQLPlus but when I run through a browser using XSQL I receive the ORA-00911: invalid character error message.

Any help is most appreciated.

Truegilly

[Updated on: Tue, 30 January 2007 07:30]

Report message to a moderator

Previous Topic: javax.servlet.ServletException: Exception creating DataSource: org.hsql.jdbcDriver
Next Topic: Oracle Cursors with java/jdbc - Millions of rows?
Goto Forum:
  


Current Time: Sun Nov 24 13:54:28 CST 2024