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