xml functions not found after enabling XML in Sybase ASE

[Shawn]

After enabling XML in ASE 15.5, I try to create a table with computed
column using xml_extract and get error message:

Function 'xml_extract' not found. If this is a SQLJ function or SQL
function, use sp_help to check whether the object exists (sp_help may
produce a large amount of output).
Msg: 14216, Level: 16, State: 1
Server: SYBPROD, Line: 1

I thought enabling XML was enough. What I am missing?


Some system details:
* ASE 15.5 on RedHat Enterprise Linux

* ASE version:
Adaptive Server Enterprise/15.5/EBF 17795 SMP ESD#1/P/x86_64/
Enterprise Linux/asear155/2495/64-bit/FBO/Thu May 27 06:07:23 2010

* License option ASE_SERVER, ASE_JAVA, ASE_XML are all enabled


shawn

[Shawn]

Post by Shawn
After enabling XML in ASE 15.5, I try to create a table with computed
Function 'xml_extract' not found. If this is a SQLJ function or SQL
function, use sp_help to check whether the object exists (sp_help may
produce a large amount of output).
 Msg: 14216, Level: 16, State: 1
 Server: SYBPROD, Line: 1
I thought enabling XML was enough.  What I am missing?
* ASE 15.5 on RedHat Enterprise Linux
Adaptive Server Enterprise/15.5/EBF 17795 SMP ESD#1/P/x86_64/
Enterprise Linux/asear155/2495/64-bit/FBO/Thu May 27 06:07:23 2010
* License option ASE_SERVER, ASE_JAVA, ASE_XML are all enabled
shawn

Answered my question. It is not xml_extract() as state in the
Transact-SQL Users Guide (v15.5) example I was trying. It is
xmlextract().


shawn