I can't get those »String Functions that Use Pattern Matching« get to work which are referenced in
XQuery 1.0 and XPath 2.0 Functions and Operators.
Are they not (yet) supported or am I doing simply something wrong?:
SQL> SELECT *
FROM XMLTABLE('for $i in matches("abracadabra", "bra")
return $i')
*
Error at line 3
ORA-19112: error raised during evaluation: oracle.xquery.XQException: XP0017: It is a static error if the expanded QName and number of arguments in a function call do not match the name and arity of an in-scope function in the static context.
Detail: unknown function 'matches'
SQL> SELECT *
FROM XMLTABLE('for $i in tokenize("The cat sat on the mat", "\s+")
return $i')
*
Error at line 2
ORA-19112: error raised during evaluation: oracle.xquery.XQException: XP0017: It is a static error if the expanded QName and number of arguments in a function call do not match the name and arity of an in-scope function in the static context.
Detail: unknown function 'tokenize'
SQL> SELECT *
FROM XMLTABLE('for $i in replace("abracadabra", "bra", "*")
return $i')
*
Error at line 2
ORA-19112: error raised during evaluation: oracle.xquery.XQException: XP0017: It is a static error if the expanded QName and number of arguments in a function call do not match the name and arity of an in-scope function in the static context.
Detail: unknown function 'replace'
Regards,
Michael