Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Validate XML Instance Against Schema

407338Mar 22 2006 — edited Mar 23 2006
Hi Mark and other gurus,
I am trying to validate the XML instance against the schema using the sample this code I found in Oralce docs,

DECLARE
xmldoc XMLType;
BEGIN
-- Populate xmldoc (for example, by fetching from table).
-- Validate against XML schema
xmldoc.isSchemaValid('http://www.oracle.com/PO.xsd');
IF xmldoc.isSchemaValid = 1 THEN --
ELSE --
END IF;
END;

in my function that generates the XML data (I have posted here two days ago asking for help to avoid the empty tags). I copied the function name from the sample. But I get this error,

PLS-00221: 'ISSCHEMAVALID' is not a procedure or is undefined

We are on 9.2 and I thought it was because 9.2 did not have that, so I tried it in 10.2. But I get the same error.

Please help. Thank you.

Ben
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2006
Added on Mar 22 2006
17 comments
5,434 views