GaramX

SELECT xt.*
  FROM xmltable('/persons/person' parsing xmltype (:x_xml)
  COLUMNS
  empno varchar2(10) path 'empno',
  empnm varchar2(50) path 'emp_nm') xt

SELECT *
  FROM xmltable('123,123')