problem of consuming xml message stored in database

hi,

earlier i had a issue of storing a xml directly into a field in database.i am able to do it.

thanks for the help.

now later i want to use this xml message stored in database to insert an order in other system.

how should i query this xml message stored according to orderid using sql adapter of type receive.

i tried by writing a stored procedure and using sql adapter of type recv.the schema generated gives a error that one of types is not defined.as the message contains xml itself.

i was not able to select that data using xml elements,xmldata or xml auto as it contains an entire xml with namespace.

after getting this xml message in db as one field in schema, i want to contruct the message for schema to which xml in database corresponds.

then after constructing that message i will be able to process it further.

please help it is urgent.