XML processing in pro * c

 Hi,

A) I have created the table like the following:

create table PurchaseOrders
(id number primary key,
xmlpo xmltype); 

I have stored the following as a string called str in Pro*C:

 EXEC SQL BEGIN DECLARE SECTION;
 char str[30000000];
 EXEC SQL END DECLARE SECTION;

<?xml version="1.0"?>
<purchaseOrder orderDate="1999-10-20">
  <shipTo country="US">
    <name>Alice Smith</name>
    <street>123 Maple Street</street>
    <city>Mill Valley</city>
    <state>CA</state>
    <zip>90952</zip>
  </shipTo>
  <billTo country="US">
    <name>Robert Smith</name>
    <street>8 Oak Avenue</street>
    <city>Old Town</city>
    <state>PA</state>
    <zip>95819</zip>
  </billTo>
  <comment>Hurry, my lawn is going wild!</comment>