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,
Julie
-- Oracle 10.2.0.1, Windows XP --
dBforums
>
Insert on XMLType View gives ORA-01733: virtual column not allowed here
10-14-07, 07:18
Insert on XMLType View gives ORA-01733: virtual column not allowed here
Linear Mode
