Simple SELECT query but no results


Simple SELECT query but no results

Hi All,


I am running teradata version 15, and i am trying to query a table with 3 columns, but i keep getting errors after errors.


SyntaxEditor Code Snippet

 SELECT a.StoreName, a.Books.xmlextract ('/note/heading[1]',NULL)  FROM    WORK_DB.SampleBooks a

I see an error


9881 function XMLCLIENTFMTTTXT called with invalid number of params.


I am really surprised, as i took this query from teradata guide, and many of the java programs i wrote also give me the same error.

Please advise experts