DevOps, CI/CD and Automation

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!

Using XMLTABLE to extract data to use in pl/sql code

1058542Dec 4 2013

I have an XML message, from which I need to extract the highlighed data and use those values to UPDATE some oracle tables. I am new to the XMLTABLE function and am having difficulty doing that. I would really appreciate some help. The first 2 values I need are CaseTrackingID and CaseDocketId. I have made those BOLD.

<CaseResponseMessage xsi:schemaLocation="urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CaseResponseMessage-4.0 C:\ecf-v4.01-spec-csd01_files\xsd\message\ECF-4.0-CaseResponseMessage.xsd"

xmlns="urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CaseResponseMessage-4.0"

xmlns:j="http://niem.gov/niem/domains/jxdm/4.0"

xmlns:ecf="urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CommonTypes-4.0"

xmlns:nc="http://niem.gov/niem/niem-core/2.0"

xmlns:s="http://niem.gov/niem/structures/2.0">

<ecf:SendingMDELocationID>

<nc:IdentificationID/>

</ecf:SendingMDELocationID>

<ecf:SendingMDEProfileCode/>

<j:CaseCourt/>

<ecf:Error>

<ecf:ErrorCode>0</ecf:ErrorCode>

<ecf:ErrorText>No error</ecf:ErrorText>

</ecf:Error>

<court:CourtCase xmlns:court="urn:tyler:ecf:extensions:CourtCase">

<nc:CaseTitleText></nc:CaseTitleText>

<nc:CaseCategoryText>7</nc:CaseCategoryText>

<nc:CaseTrackingID>4812</nc:CaseTrackingID>

<nc:CaseDocketID>2013-001119</nc:CaseDocketID>

<court:CaseTypeText>1764</court:CaseTypeText>

<court:CaseOtherDocketID/>

<j:CaseAugmentation>

<j:CaseCourt>

<nc:OrganizationIdentification>

<nc:IdentificationID>hcdistrictclerk.com</nc:IdentificationID>

</nc:OrganizationIdentification>

<j:CourtName/>

</j:CaseCourt>

<j:CaseLineageCase>

<nc:CaseTrackingID>2889663e-217e-4a99-a8b4-0058f88b4dec</nc:CaseTrackingID>

</j:CaseLineageCase>

</j:CaseAugmentation>

<ecf:CaseAugmentation>

<ecf:CaseOtherEntityAttorney>

<nc:RoleOfPersonReference s:ref="Attorney2"/>

<j:JudicialOfficialBarMembership>

<j:JudicialOfficialBarIdentification>

<nc:IdentificationID>123456</nc:IdentificationID>

<j:IdentificationJurisdictionNCICLISCode>TX</j:IdentificationJurisdictionNCICLISCode>

</j:JudicialOfficialBarIdentification>

</j:JudicialOfficialBarMembership>

<ecf:CaseRepresentedPartyReference s:ref="Party2"/>

</ecf:CaseOtherEntityAttorney>

<ecf:CaseOtherEntityAttorney>

<nc:RoleOfPersonReference s:ref="Attorney1"/>

<j:JudicialOfficialBarMembership>

<j:JudicialOfficialBarIdentification>

<nc:IdentificationID>123456</nc:IdentificationID>

<j:IdentificationJurisdictionNCICLISCode>TX</j:IdentificationJurisdictionNCICLISCode>

</j:JudicialOfficialBarIdentification>

</j:JudicialOfficialBarMembership>

<ecf:CaseRepresentedPartyReference s:ref="Party1"/>

</ecf:CaseOtherEntityAttorney>

<ecf:CaseParticipant>

<ecf:EntityPerson s:id="Attorney1">

<nc:PersonName>

<nc:PersonGivenName>Joe</nc:PersonGivenName>

<nc:PersonMiddleName></nc:PersonMiddleName>

<nc:PersonSurName>Singleton</nc:PersonSurName>

</nc:PersonName>

<nc:PersonOtherIdentification>

<nc:IdentificationID>5d12a9cc-1533-4eac-b2c6-3d64a42baa0e</nc:IdentificationID>

<nc:IdentificationCategoryText>CASEPARTYATTORNEYID</nc:IdentificationCategoryText>

</nc:PersonOtherIdentification>

<ecf:PersonAugmentation>

<nc:ContactInformation>

<nc:ContactTelephoneNumber>

<nc:FullTelephoneNumber>

<nc:TelephoneNumberFullID>210-403-8600</nc:TelephoneNumberFullID>

</nc:FullTelephoneNumber>

</nc:ContactTelephoneNumber>

<nc:ContactEmailID/>

<nc:ContactMailingAddress>

<nc:StructuredAddress>

<nc:LocationStreet>

<nc:StreetFullText>911 Central PKWY N, Ste 110</nc:StreetFullText>

</nc:LocationStreet>

<nc:AddressSecondaryUnitText></nc:AddressSecondaryUnitText>

<nc:LocationCityName>San Antonio</nc:LocationCityName>

<nc:LocationStateName>TX</nc:LocationStateName>

<nc:LocationCountryFIPS10-4Code>US</nc:LocationCountryFIPS10-4Code>

<nc:LocationPostalCode>78232</nc:LocationPostalCode>

</nc:StructuredAddress>

</nc:ContactMailingAddress>

</nc:ContactInformation>

</ecf:PersonAugmentation>

</ecf:EntityPerson>

<ecf:CaseParticipantRoleCode>ATTY</ecf:CaseParticipantRoleCode>

</ecf:CaseParticipant>

<ecf:CaseParticipant>

<ecf:EntityOrganization s:id="Party1">

<nc:OrganizationName>Harris County</nc:OrganizationName>

<nc:OrganizationIdentification>

<nc:IdentificationID>a174d1a1-0ce2-4a6a-984e-998b890d3e6f</nc:IdentificationID>

<nc:IdentificationCategoryText>CASEPARTYID</nc:IdentificationCategoryText>

</nc:OrganizationIdentification>

<ecf:OrganizationAugmentation>

<nc:ContactInformation>

<nc:ContactTelephoneNumber>

<nc:FullTelephoneNumber>

<nc:TelephoneNumberFullID>7138443400</nc:TelephoneNumberFullID>

</nc:FullTelephoneNumber>

</nc:ContactTelephoneNumber>

<nc:ContactEmailID/>

<nc:ContactMailingAddress>

<nc:StructuredAddress>

<nc:LocationStreet>

<nc:StreetFullText>P O BOX 3064</nc:StreetFullText>

</nc:LocationStreet>

<nc:AddressSecondaryUnitText></nc:AddressSecondaryUnitText>

<nc:LocationCityName>Houston</nc:LocationCityName>

<nc:LocationStateName>TX</nc:LocationStateName>

<nc:LocationCountryFIPS10-4Code>US</nc:LocationCountryFIPS10-4Code>

<nc:LocationPostalCode>772533064</nc:LocationPostalCode>

</nc:StructuredAddress>

</nc:ContactMailingAddress>

</nc:ContactInformation>

</ecf:OrganizationAugmentation>

</ecf:EntityOrganization>

<ecf:CaseParticipantRoleCode>1690</ecf:CaseParticipantRoleCode>

</ecf:CaseParticipant>

<ecf:CaseParticipant>

<ecf:EntityPerson s:id="Attorney2">

<nc:PersonName>

<nc:PersonGivenName>Joe</nc:PersonGivenName>

<nc:PersonMiddleName></nc:PersonMiddleName>

<nc:PersonSurName>Singleton</nc:PersonSurName>

</nc:PersonName>

<nc:PersonOtherIdentification>

<nc:IdentificationID>76ff5e18-9c9a-4957-af4f-64ffa5217cd1</nc:IdentificationID>

<nc:IdentificationCategoryText>CASEPARTYATTORNEYID</nc:IdentificationCategoryText>

</nc:PersonOtherIdentification>

<ecf:PersonAugmentation>

<nc:ContactInformation>

<nc:ContactTelephoneNumber>

<nc:FullTelephoneNumber>

<nc:TelephoneNumberFullID>210-403-8600</nc:TelephoneNumberFullID>

</nc:FullTelephoneNumber>

</nc:ContactTelephoneNumber>

<nc:ContactEmailID/>

<nc:ContactMailingAddress>

<nc:StructuredAddress>

<nc:LocationStreet>

<nc:StreetFullText>911 Central PKWY N, Ste 110</nc:StreetFullText>

</nc:LocationStreet>

<nc:AddressSecondaryUnitText></nc:AddressSecondaryUnitText>

<nc:LocationCityName>San Antonio</nc:LocationCityName>

<nc:LocationStateName>TX</nc:LocationStateName>

<nc:LocationCountryFIPS10-4Code>US</nc:LocationCountryFIPS10-4Code>

<nc:LocationPostalCode>78232</nc:LocationPostalCode>

</nc:StructuredAddress>

</nc:ContactMailingAddress>

</nc:ContactInformation>

</ecf:PersonAugmentation>

</ecf:EntityPerson>

<ecf:CaseParticipantRoleCode>ATTY</ecf:CaseParticipantRoleCode>

</ecf:CaseParticipant>

<ecf:CaseParticipant>

<ecf:EntityOrganization s:id="Party2">

<nc:OrganizationName>City of South Houston</nc:OrganizationName>

<nc:OrganizationIdentification>

<nc:IdentificationID>0b04f15a-226d-417f-92e7-8d9088577121</nc:IdentificationID>

<nc:IdentificationCategoryText>CASEPARTYID</nc:IdentificationCategoryText>

</nc:OrganizationIdentification>

<ecf:OrganizationAugmentation>

<nc:ContactInformation>

<nc:ContactTelephoneNumber>

<nc:FullTelephoneNumber>

<nc:TelephoneNumberFullID>7138443400</nc:TelephoneNumberFullID>

</nc:FullTelephoneNumber>

</nc:ContactTelephoneNumber>

<nc:ContactEmailID/>

<nc:ContactMailingAddress>

<nc:StructuredAddress>

<nc:LocationStreet>

<nc:StreetFullText>P O BOX 3064</nc:StreetFullText>

</nc:LocationStreet>

<nc:AddressSecondaryUnitText></nc:AddressSecondaryUnitText>

<nc:LocationCityName>Houston</nc:LocationCityName>

<nc:LocationStateName>TX</nc:LocationStateName>

<nc:LocationCountryFIPS10-4Code>US</nc:LocationCountryFIPS10-4Code>

<nc:LocationPostalCode>772533064</nc:LocationPostalCode>

</nc:StructuredAddress>

</nc:ContactMailingAddress>

</nc:ContactInformation>

</ecf:OrganizationAugmentation>

</ecf:EntityOrganization>

<ecf:CaseParticipantRoleCode>1690</ecf:CaseParticipantRoleCode>

</ecf:CaseParticipant>

<ecf:CaseParticipant>

<ecf:EntityPerson s:id="Party3">

<nc:PersonBirthDate>

<nc:Date xsi:nil="true"/>

</nc:PersonBirthDate>

<nc:PersonName>

<nc:PersonGivenName>Joseph</nc:PersonGivenName>

<nc:PersonMiddleName>K.</nc:PersonMiddleName>

<nc:PersonSurName>Singleton</nc:PersonSurName>

<nc:PersonNameSuffixText></nc:PersonNameSuffixText>

</nc:PersonName>

<nc:PersonOtherIdentification>

<nc:IdentificationID>c86a92ef-35a4-449f-a729-1bc0c1f769f6</nc:IdentificationID>

<nc:IdentificationCategoryText>CASEPARTYID</nc:IdentificationCategoryText>

</nc:PersonOtherIdentification>

<nc:PersonRaceText/>

<nc:PersonSexCode xsi:nil="true"/>

<ecf:PersonAugmentation>

<nc:ContactInformation>

<nc:ContactTelephoneNumber>

<nc:FullTelephoneNumber>

<nc:TelephoneNumberFullID>7138443400</nc:TelephoneNumberFullID>

</nc:FullTelephoneNumber>

</nc:ContactTelephoneNumber>

<nc:ContactEmailID/>

<nc:ContactMailingAddress>

<nc:StructuredAddress>

<nc:LocationStreet>

<nc:StreetFullText>P O BOX 3064</nc:StreetFullText>

</nc:LocationStreet>

<nc:AddressSecondaryUnitText></nc:AddressSecondaryUnitText>

<nc:LocationCityName>Houston</nc:LocationCityName>

<nc:LocationStateName>TX</nc:LocationStateName>

<nc:LocationCountryFIPS10-4Code>US</nc:LocationCountryFIPS10-4Code>

<nc:LocationPostalCode>772533064</nc:LocationPostalCode>

</nc:StructuredAddress>

</nc:ContactMailingAddress>

</nc:ContactInformation>

</ecf:PersonAugmentation>

</ecf:EntityPerson>

<ecf:CaseParticipantRoleCode>1679</ecf:CaseParticipantRoleCode>

</ecf:CaseParticipant>

<ecf:CaseParticipant>

<ecf:EntityPerson s:id="Party4">

<nc:PersonBirthDate>

<nc:Date xsi:nil="true"/>

</nc:PersonBirthDate>

<nc:PersonName>

<nc:PersonGivenName>Raul</nc:PersonGivenName>

<nc:PersonMiddleName></nc:PersonMiddleName>

<nc:PersonSurName>Garza</nc:PersonSurName>

<nc:PersonNameSuffixText></nc:PersonNameSuffixText>

</nc:PersonName>

<nc:PersonOtherIdentification>

<nc:IdentificationID>15440071-302d-44f1-82e4-3fc930532049</nc:IdentificationID>

<nc:IdentificationCategoryText>CASEPARTYID</nc:IdentificationCategoryText>

</nc:PersonOtherIdentification>

<nc:PersonRaceText/>

<nc:PersonSexCode xsi:nil="true"/>

<ecf:PersonAugmentation>

<nc:ContactInformation>

<nc:ContactTelephoneNumber>

<nc:FullTelephoneNumber>

<nc:TelephoneNumberFullID></nc:TelephoneNumberFullID>

</nc:FullTelephoneNumber>

</nc:ContactTelephoneNumber>

<nc:ContactEmailID/>

<nc:ContactMailingAddress>

<nc:StructuredAddress>

<nc:LocationStreet>

<nc:StreetFullText>222 South Fork</nc:StreetFullText>

</nc:LocationStreet>

<nc:AddressSecondaryUnitText></nc:AddressSecondaryUnitText>

<nc:LocationCityName>Houston</nc:LocationCityName>

<nc:LocationStateName>TX</nc:LocationStateName>

<nc:LocationCountryFIPS10-4Code>US</nc:LocationCountryFIPS10-4Code>

<nc:LocationPostalCode>77148</nc:LocationPostalCode>

</nc:StructuredAddress>

</nc:ContactMailingAddress>

</nc:ContactInformation>

</ecf:PersonAugmentation>

</ecf:EntityPerson>

<ecf:CaseParticipantRoleCode>1666</ecf:CaseParticipantRoleCode>

</ecf:CaseParticipant>

<ecf:CaseParticipant>

<ecf:EntityPerson s:id="Party5">

<nc:PersonBirthDate>

<nc:Date xsi:nil="true"/>

</nc:PersonBirthDate>

<nc:PersonName>

<nc:PersonGivenName>Sandra</nc:PersonGivenName>

<nc:PersonMiddleName>A.</nc:PersonMiddleName>

<nc:PersonSurName>Garza</nc:PersonSurName>

<nc:PersonNameSuffixText></nc:PersonNameSuffixText>

</nc:PersonName>

<nc:PersonOtherIdentification>

<nc:IdentificationID>c346477d-90eb-4323-b082-7cc8edc6d143</nc:IdentificationID>

<nc:IdentificationCategoryText>CASEPARTYID</nc:IdentificationCategoryText>

</nc:PersonOtherIdentification>

<nc:PersonRaceText/>

<nc:PersonSexCode xsi:nil="true"/>

<ecf:PersonAugmentation>

<nc:ContactInformation>

<nc:ContactTelephoneNumber>

<nc:FullTelephoneNumber>

<nc:TelephoneNumberFullID></nc:TelephoneNumberFullID>

</nc:FullTelephoneNumber>

</nc:ContactTelephoneNumber>

<nc:ContactEmailID/>

<nc:ContactMailingAddress>

<nc:StructuredAddress>

<nc:LocationStreet>

<nc:StreetFullText>L J Garage</nc:StreetFullText>

</nc:LocationStreet>

<nc:AddressSecondaryUnitText>902 Arkansas St</nc:AddressSecondaryUnitText>

<nc:LocationCityName>South Houston</nc:LocationCityName>

<nc:LocationStateName>TX</nc:LocationStateName>

<nc:LocationCountryFIPS10-4Code>US</nc:LocationCountryFIPS10-4Code>

<nc:LocationPostalCode>775874916</nc:LocationPostalCode>

</nc:StructuredAddress>

</nc:ContactMailingAddress>

</nc:ContactInformation>

</ecf:PersonAugmentation>

</ecf:EntityPerson>

<ecf:CaseParticipantRoleCode>1666</ecf:CaseParticipantRoleCode>

</ecf:CaseParticipant>

</ecf:CaseAugmentation>

</court:CourtCase>

</CaseResponseMessage>

</GetCaseResponse>

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2014

Added on Dec 4 2013

#pl-sql-xml-programming, #xml

0 comments

952 views