Guys,
I'm trying to load an XML in one of my dba_directories into into XMLtype column table.
This is my XML:
<?xml version="1.0" encoding="UTF-8" ?>
<NewDataSet>
<excelTable>
<_x002D_>GSG Dollars</_x002D_>
<Department>BA52</Department>
<PCS_x0020_Contract_x0020_Tag>MD-3GSM</PCS_x0020_Contract_x0020_Tag>
<Location>Australia</Location>
<MAY_2006>21668</MAY_2006>
</excelTable>
<excelTable>
<_x002D_>GSG Dollars</_x002D_>
<Department>BA501</Department>
<PCS_x0020_Contract_x0020_Tag>MD-3GSM</PCS_x0020_Contract_x0020_Tag>
<Location>China</Location>
<MAY_2006>8166</MAY_2006>
</excelTable>
<excelTable>
<_x002D_>GSG Dollars</_x002D_>
<Department>BA522</Department>
<PCS_x0020_Contract_x0020_Tag>MD-3GSM</PCS_x0020_Contract_x0020_Tag>
<Location>Australia</Location>
<MAY_2006>21668</MAY_2006>
</excelTable>
</NewDataSet>
INSERT INTO XML_TAB VALUES (XMLType(bfilename ('ATTACH_FILES', 'test.xml'),nls_charset_id('WE8ISO8859P1')));
I've been unsuccesful with the error below:
ERROR at line 1:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'
Please help with thoughts\suggestions for me to get out of this error
Thanks,
Bhagat