Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007

    Cool Unanswered: ORA-00911: invalid character when using X-path in XSQL

    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 s.OBJECT_VALUE.extract('/shipDetails/shipBearing/text()').getnumberVal()
    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.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts