Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2007
    Dedham, MA

    Exclamation Unanswered: Insert on XMLType View gives ORA-01733: virtual column not allowed here

    I'm trying to read some XML from a file and insert it into an XMLType view. This should work. The object view and XMLType view are created successfully as well as all associated column types. No column names have spaces or quotes or anything. There are no quotes in the sample xml data. I'm not really sure why this is happening. I have attached a file with relevant code.

    This matter is of some urgency to me. Any help offered would be greatly appreciated. Feel free to IM or email me with suggestions. There are a lot of object types used in the object view definition, I don't know if you really need that info. But, if more info is needed, please let me know.

    Kindest Regards,

    -- Oracle, Windows XP --
    Attached Files Attached Files

Posting Permissions

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