select T.id
from Table1 T,
xmltable ('/Table1/data'
passing w.metadata
columns name varchar2(50) PATH '/data/name',
status varchar2(50) PATH '/data/status');

ORA-19224: XPTY0004 - XQuery static type mismatch: expected - %s got - %s
 *Cause: The expression could not be used because it's static type is not 
         appropriate for the context in which it was used.
 *Action: Fix the expression to be of the required type or add appropriate 
          cast functions around the expression.