Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to remove namespace Prefix ns0

KrishNov 30 2007 — edited Dec 27 2007
Hi ,

I receive an xml from an external service.In that each element in prefixed by namespace ns0: How can I remove that name space.I trieed using
ora:ProcessXSLT.But its not working.Its giving TypeError

Please find below my xml and xslt files.

XML ---

<ProcessSalesLead xmlns:ns0="http://www.starstandards.org/STAR/ProcessSalesLead" revision="3.0" release="8.1-Lite" environment="Production" lang="en-US" xmlns="http://webservice.services.freeway.wipro.com">
<ns0:ApplicationArea>
<ns0:Sender>
<ns0:Component>String</ns0:Component>
<ns0:Task>SalesLead</ns0:Task>
<ns0:ReferenceId>1-4CPJ</ns0:ReferenceId>
<ns0:CreatorNameCode>XX</ns0:CreatorNameCode>
<ns0:SenderNameCode>XX</ns0:SenderNameCode>
</ns0:Sender>
<ns0:CreationDateTime>2007-11-28T15:33:16+05:30</ns0:CreationDateTime>
<ns0:Destination>
<ns0:DestinationNameCode>XX</ns0:DestinationNameCode>
<ns0:DealerNumber>10005</ns0:DealerNumber>
</ns0:Destination>
</ns0:ApplicationArea>
<ns0:DataArea>
<ns0:Process acknowledge="Never" confirm="Always"/>
<ns0:SalesLead>
<ns0:Header>
<ns0:DocumentId>1-4CPJ</ns0:DocumentId>
<ns0:IndividualProspect>
<ns0:PersonName>
<ns0:GivenName>Ray</ns0:GivenName>
<ns0:FamilyName>Aamos</ns0:FamilyName>
</ns0:PersonName>
<ns0:Address>
<ns0:AddressLine>1200 Davisville Rd</ns0:AddressLine>
<ns0:City>York</ns0:City>
<ns0:StateOrProvince>AL</ns0:StateOrProvince>
<ns0:Country>US</ns0:Country>
<ns0:PostalCode>78201</ns0:PostalCode>
</ns0:Address>
<ns0:Contact>
<ns0:Telephone desc="Day Phone">2018742349</ns0:Telephone>
<ns0:EMailAddress desc="Work">raamos@abbeygeneral.org</ns0:EMailAddress>
<ns0:Fax desc="Work">2018745698</ns0:Fax>
</ns0:Contact>
<ns0:OwnedVehicle>
<ns0:Model>Sonata</ns0:Model>
<ns0:ModelYear>2006</ns0:ModelYear>
<ns0:Make>Hyundai</ns0:Make>
</ns0:OwnedVehicle>
</ns0:IndividualProspect>
<ns0:Provider>
<ns0:Contact>
<ns0:PersonName>
<ns0:GivenName/>
<ns0:FamilyName/>
</ns0:PersonName>
</ns0:Contact>
</ns0:Provider>
<ns0:Dealer>
<ns0:DealerName>Metro Motors Florida</ns0:DealerName>
<ns0:Address>
<ns0:AddressLine>Miami</ns0:AddressLine>
<ns0:City>Miami</ns0:City>
<ns0:StateOrProvince>FL</ns0:StateOrProvince>
<ns0:Country>US</ns0:Country>
<ns0:PostalCode>33010</ns0:PostalCode>
</ns0:Address>
<ns0:SalesContact>
<ns0:Telephone desc="Day Phone">3058938000</ns0:Telephone>
</ns0:SalesContact>
<ns0:OrganizationName>Metro Motors Florida</ns0:OrganizationName>
</ns0:Dealer>
<ns0:LeadComments>Existing Vehicle info</ns0:LeadComments>
</ns0:Header>
<ns0:Detail>
<ns0:LeadStatus>Accepted</ns0:LeadStatus>
<ns0:SalesVehicle>
<ns0:Model>Camry</ns0:Model>
<ns0:ModelYear>2007</ns0:ModelYear>
<ns0:ModelDescription>Camry LE</ns0:ModelDescription>
<ns0:Make>Toyota</ns0:Make>
<ns0:VehicleNote/>
<ns0:ExteriorColor/>
<ns0:TransmissionType>A</ns0:TransmissionType>
</ns0:SalesVehicle>
</ns0:Detail>
</ns0:SalesLead>
</ns0:DataArea>
</ProcessSalesLead>


XSLT --

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:template match="*">
<!-- remove element prefix (if any) -->
<xsl:element name="{local-name()}">
<!-- process attributes -->
<xsl:for-each select="@*">
<!-- remove attribute prefix (if any) -->
<xsl:attribute name="{local-name()}">
<xsl:value-of select="."/>
</xsl:attribute>
</xsl:for-each>
<xsl:apply-templates/>
</xsl:element>
</xsl:template>
</xsl:stylesheet>


Please help me on this.Its very urgent .

thanks
deepthi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 24 2008
Added on Nov 30 2007
9 comments
3,037 views