Database Software

Hello:
I have the following table and in the XML_MESSAGE column is the xml listed below:

The query listed below does not seem to return any rows...???

Any Ideas?

Thanks, Don


CREATE TABLE TELETRAC_XML_MESSAGES(
TELETRAC_XML_MESSAGE_ID NUMBER NOT NULL,
TMX_STATUS VARCHAR2(10) NOT NULL,
TMX_TYPE VARCHAR2(10) NOT NULL,
INSERT_DATE DATE NOT NULL,
XML_MESSAGE XMLTYPE);

ALTER TABLE TELETRAC_XML_MESSAGES ADD CONSTRAINT TMX_PK PRIMARY KEY (TELETRAC_XML_MESSAGE_ID);


--THE XML IN TELETRAC_XML_MESSAGES.XML_MESSAGE FOLLOWS:



<?xml version="1.0" encoding="utf-8"?>
<SendMessageResult xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://urt.teletrac.net/">
<MessageEcho>"ADISPATCHID3^0710100000^DONSTEGER^3500 TREE LANE^MADISON^WI^53717^6088334073^^^TEST_MESSAGE" sent to vehicle: test.</MessageEcho>
<Error>
<ID>0</ID>
<Description />
</Error>
</SendMessageResult>



--DID NOT WORK, NO ROWS RETURNED ANY IDEAS????
SELECT TELETRAC_XML_MESSAGE_ID,
TMX_STATUS,
TMX_TYPE,
TMX.MESSAGE_ECHO,
TMX.MESSAGE_ERROR,
TMX.MESSAGE_ID,
TMX.MESSAGE_DESCRIPTION
FROM TELETRAC_XML_MESSAGES,
XMLTABLE(
XMLNamespaces(default 'http://urt.teletrac.net/'),
'/SendMessagesResult'
PASSING TELETRAC_XML_MESSAGES.XML_MESSAGE
COLUMNS
MESSAGE_ECHO VARCHAR2(200) PATH 'MessageEcho',
MESSAGE_ERROR VARCHAR2(200) PATH 'Error',
MESSAGE_ID VARCHAR2(200) PATH 'ID',
MESSAGE_DESCRIPTION VARCHAR2(200) PATH 'Description'
) TMX;



The above query did not return any rows???