Subject | process XML in stored procedure |
---|---|
Author | jclichthouse |
Post date | 2011-07-02T19:39:03Z |
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]
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]