Subject process XML in stored procedure
Author jclichthouse
Hello everybody,

After a search to convert the MS-Sql to Firebird i found a problem.
Firebird is not a able to work with XML.

Can somebody tel my if there is tool/UDF for this, if not some help/info
about creating a udf in C# would be appreciated ( can not write/read
C/C++ yet ).

This is what i no / need to do:
the stored procedure has a parameter string that contains the XML. I
need to read the XML and load it in a ( temp ) table.

Here is a example of XML
<DocumentElement><Phone><PhoneTypeNR>1</TelTypeNR>
<LandNr>31</LandNr>
<Netnummer>06</Netnummer>
<AbonneeNr>6060606</AbonneeNr></Phone>
<Phone>
<PhoneTypeNR>4</TelTypeNR>
<LandNr>31</LandNr>
<Netnummer>0475</Netnummer>
<AbonneeNr>8080808</AbonneeNr></Phone></DocumentElement>

If you want to know more please read this thread
http://tech.groups.yahoo.com/group/IB-Conversions/message/657
Title: Convert ms-sql to firebird openxml problem

Thanks,

Edwin


[Non-text portions of this message have been removed]