This content has been marked as final. Show 5 replies
xmltype( blobcol, nls_charset_id( 'AL32UTF8' ) )
i got infromation that it is depricated that is way i am not using it.
Starting 11gR2, Oracle has deprecated many older proprietary mainly XPath 1.0 based operators
in favor of standards based XQuery syntax,
xmltype is not depricated, but using clob storage for a xmltype is. Use one of the blob storage models. See for instance http://www.liberidu.com/blog/2008/09/05/xmldb-performance-xml-binary-xml-storage-models/ But don't store a XML as clob or blob
well we where not talking about xmltype (type)
we where talking about xmltype() ( function)
so does this function comes under
older proprietary mainly XPath 1.0 based operators(depricated)
if yes then some
standard based XQuery syntax, exists . some where i read about xmlparser().
Well, I was talking about XMLtype (type ) and its constructors. And that has nothing to do XPath or Xquery or deprication.
I would suggest that you always use the most appropriate datatype for storing your data, i.e. use XMLtype for XML, clob for large text and blob for binary data.
And for the use of (depricated) Xquery or Xpath functions and operators exists another forum, XML DB