Oracle XML format

Hi,

I need help in writing an xml file, that contains a record to a table, which can be read through a oracle database.

For example,
if you pass a record value as a text message through a XML file the Oracle database should add the field values to the tables. Record can be -
1|22|237|'weeeee'|'K_P|'DAY'|TO_Date('05/02/2001 01:53:18 PM','MM/DD/YYYY HH:MI:SS AM')|NULL|TEST Oracle should be able delimiter the string by "|" (or any other) and insert the values to the correct table.

To accommodate this problem, how can the format of the XML file be? What should it contain?

Thanks Received on Wed Jan 15 2003 - 18:18:25 CST