01-30-07, 08:18 #1Registered User
- Join Date
- Jan 2007
Unanswered: ORA-00911: invalid character when using X-path in XSQL
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 s.OBJECT_VALUE.extract('/shipDetails/shipBearing/text()').getnumberVal() FROM ship s;
Any help is most appreciated.
01-30-07, 11:41 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
00911, 00000, "invalid character"
// *Cause: identifiers may not start with any ASCII character other than
// letters and numbers. $#_ are also allowed after the first
// character. Identifiers enclosed by doublequotes may contain
// any character other than a doublequote. Alternative quotes
// (q'#...#') cannot use spaces, tabs, or carriage returns as
// delimiters. For all other contexts, consult the SQL Language
// Reference Manual.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.