PL/SQL :: How To Load XML File Into Table

I've been working on Oracle for many years but fot the first time I was asked to load a XML file into a table.As an example, I've found this on the web, but it doesn't work. the file acct.xml is this:

 <?xml version="1.0"?><ACCOUNT_HEADER_ACK><HEADER><STATUS_CODE>100</STATUS_CODE><STATUS_REMARKS>check</STATUS_REMARKS></HEADER><DETAILS><DETAIL><SEGMENT_NUMBER>2</SEGMENT_NUMBER><REMARKS>rp polytechnic</REMARKS></DETAIL><DETAIL><SEGMENT_NUMBER>3</SEGMENT_NUMBER><REMARKS>rp polytechnic administration</REMARKS></DETAIL><DETAIL><SEGMENT_NUMBER>4</SEGMENT_NUMBER><REMARKS>rp polytechnic finance</REMARKS>[code]......

 For the two tags HEADER and DETAILS I have the table: 

create table xxrp_acct_details(status_code number,status_remarks varchar2(100),segment_number number,remarks varchar2(100)); 

before I've created a create directory test_dir as 'c:esterno'; --

where I have my acct.xml and after, can you give me a script for loading data by using XMLTABLE? I've tried this but it doesn't work: 

DECLARE acct_doc xmltype := xmltype( bfilename('TEST_DIR','acct.xml'), nls_charset_id('AL32UTF8') );BEGIN insert into xxrp_acct_details (status_code, status_remarks, segment_number, remarks) select x1.status_code,         x1.status_remarks,        x2.segment_number,         x2.remarks from xmltable(  '/ACCOUNT_HEADER_ACK/HEADER'  [code]......

This should allow me to get something like this: select * from xxrp_acct_details; Statuscode status remarks segement remarks --------------- -------------------- ------------- ------------ 100 check 2 rp polytechnic100 check 3 rp polytechnic administration100 check 4 rp polytechnic finance100 check 5 rp polytechnic logistics500 process exception 20 base polytechnic500 process exception 30500 process exception 40 base polytechnic finance500 process exception 50 base polytechnic logistics but I get:

 Error report:ORA-06550: line 19, column 11:PL/SQL: ORA-00932: inconsistent datatypes: expected - got NUMBERORA-06550: line 4, column 2:PL/SQL: SQL Statement ignored06550. 00000 -  "line %s, column %s:

%s"*Cause:    Usually a PL/SQL compilation error. and if I try to change the script without using the column HEADER_NO o keep track of the header rank inside the document: 

DECLARE acct_doc xmltype := xmltype( bfilename('TEST_DIR','acct.xml'), nls_charset_id('AL32UTF8') );BEGIN insert into xxrp_acct_details (status_code, status_remarks, segment_number, remarks) select x1.status_code,         x1.status_remarks,        x2.segment_number,         x2.remarks from xmltable(  '/ACCOUNT_HEADER_ACK/HEADER'  [code]......

I get this message: Error report:ORA-19114: error during parsing the XQuery expression:  ORA-06550: line 1, column 13:PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredORA-06512: at line 419114. 00000 -  "error during parsing the XQuery expression: %s"*Cause:   

An error occurred during the parsing of the XQuery expression.*Action:   Check the detailed error message for the possible causes. My oracle version is 10gR2 Express Edition