OraFAQ Forum: JDeveloper, Java & XML » XML Validation (merged 4)

Home » Developer & Programmer » JDeveloper, Java & XML » XML Validation (merged 4) (Oracle, 10g, Windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XML Validation (merged 4) [message #553165]

Wed, 02 May 2012 07:57

mvmkandan
Messages: 68
Registered: May 2010
Location: Trivendrum

Member

Hi,

I have registered the xsd using "dbms_xmlschema.registerschema". After that i am getting the xml file.

We can validate the xml file by creating one oracle directory for that XML and paste the xml file inside that directory and using below query we can validate.

SELECT SYS.XMLTYPE (BFILENAME (p_i_xml_dir, p_i_xml_file_name),
                          NLS_CHARSET_ID ('UTF16')
                         ).isschemavalid (p_i_xml_file_name)

But, Is it possible to check the received xml file valid or not without creating oracle directory for that xml file.

Thanks in Advance
Veera

Report message to a moderator