SQLize | PHPize | SQLtest

begin user1.sdk_order_service_data_source.set_response( pnOSDSID => 123123, -- enter here osds.id psResponse => '<AgencyReference type="Case"> <IdValue>7</IdValue> </AgencyReference> <CourtName>Court Name</CourtName> <SubjectConfirmation> <ConfirmByProvidedName>true</ConfirmByProvidedName> <ConfirmByDateOfBirth>true</ConfirmByDateOfBirth> <ConfirmByGovernmentId>false</ConfirmByGovernmentId> <ConfirmBySex>false</ConfirmBySex> <ConfirmByRace>false</ConfirmByRace> </SubjectConfirmation> <SubjectIdentification> <PersonName type="Subject"> <FormattedName>Jane H. Doe</FormattedName> </PersonName> <PersonName type="Alias"> <FormattedName/> </PersonName> <PostalAddress> <DeliveryAddress> <AddressLine/> </DeliveryAddress> </PostalAddress> <DemographicDetail> <GovernmentId issuingAuthority="SSN" countryCode="US">444-33-2222</GovernmentId> <DateOfBirth>1962-03-17</DateOfBirth> <Race>White</Race> <GenderCode>2</GenderCode> <HairColor>Brown</HairColor> <EyeColor>Blue</EyeColor> <Height>5'' 6?</Height> <Weight>120</Weight> </DemographicDetail> <License> <LicenseNumber>ST-0000-000000</LicenseNumber> </License> </SubjectIdentification> <CaseFileDate> <AnyDate>2005-01-31</AnyDate> </CaseFileDate> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> </CriminalCase> <CriminalCase> <AgencyReference type="Case"> <IdValue>8</IdValue> </AgencyReference> <CourtName>Court Name</CourtName> <SubjectConfirmation> <ConfirmByProvidedName>true</ConfirmByProvidedName> <ConfirmByDateOfBirth>true</ConfirmByDateOfBirth> <ConfirmByGovernmentId>false</ConfirmByGovernmentId> <ConfirmBySex>false</ConfirmBySex> <ConfirmByRace>false</ConfirmByRace> </SubjectConfirmation> <SubjectIdentification> <PersonName type="Subject"> <FormattedName>Jane H. Doe</FormattedName> </PersonName> <PersonName type="Alias"> <FormattedName/> </PersonName> <PostalAddress> <DeliveryAddress> <AddressLine/> </DeliveryAddress> </PostalAddress> <DemographicDetail> <GovernmentId issuingAuthority="SSN" countryCode="US">444-33-2222</GovernmentId> <DateOfBirth>1962-03-17</DateOfBirth> <Race>White</Race> <GenderCode>2</GenderCode> <HairColor>Brown</HairColor> <EyeColor>Blue</EyeColor> <Height>5'' 6?</Height> <Weight>120</Weight> </DemographicDetail> <License> <LicenseNumber>ST-0000-000000</LicenseNumber> </License> </SubjectIdentification> <CaseFileDate> <AnyDate>2005-01-31</AnyDate> </CaseFileDate> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> </CriminalCase> <CriminalCase> <AgencyReference type="Case"> <IdValue>9</IdValue> </AgencyReference> <CourtName>Court Name</CourtName> <SubjectConfirmation> <ConfirmByProvidedName>true</ConfirmByProvidedName> <ConfirmByDateOfBirth>true</ConfirmByDateOfBirth> <ConfirmByGovernmentId>false</ConfirmByGovernmentId> <ConfirmBySex>false</ConfirmBySex> <ConfirmByRace>false</ConfirmByRace> </SubjectConfirmation> <SubjectIdentification> <PersonName type="Subject"> <FormattedName>Jane H. Doe</FormattedName> </PersonName> <PersonName type="Alias"> <FormattedName/> </PersonName> <PostalAddress> <DeliveryAddress> <AddressLine/> </DeliveryAddress> </PostalAddress> <DemographicDetail> <GovernmentId issuingAuthority="SSN" countryCode="US">444-33-2222</GovernmentId> <DateOfBirth>1962-03-17</DateOfBirth> <Race>White</Race> <GenderCode>2</GenderCode> <HairColor>Brown</HairColor> <EyeColor>Blue</EyeColor> <Height>5'' 6?</Height> <Weight>120</Weight> </DemographicDetail> <License> <LicenseNumber>ST-0000-000000</LicenseNumber> </License> </SubjectIdentification> <CaseFileDate> <AnyDate>2005-01-31</AnyDate> </CaseFileDate> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> </CriminalCase> <CriminalCase> <AgencyReference type="Case"> <IdValue>10</IdValue> </AgencyReference> <CourtName>Court Name</CourtName> <SubjectConfirmation> <ConfirmByProvidedName>true</ConfirmByProvidedName> <ConfirmByDateOfBirth>true</ConfirmByDateOfBirth> <ConfirmByGovernmentId>false</ConfirmByGovernmentId> <ConfirmBySex>false</ConfirmBySex> <ConfirmByRace>false</ConfirmByRace> </SubjectConfirmation> <SubjectIdentification> <PersonName type="Subject"> <FormattedName>Jane H. Doe</FormattedName> </PersonName> <PersonName type="Alias"> <FormattedName/> </PersonName> <PostalAddress> <DeliveryAddress> <AddressLine/> </DeliveryAddress> </PostalAddress> <DemographicDetail> <GovernmentId issuingAuthority="SSN" countryCode="US">444-33-2222</GovernmentId> <DateOfBirth>1962-03-17</DateOfBirth> <Race>White</Race> <GenderCode>2</GenderCode> <HairColor>Brown</HairColor> <EyeColor>Blue</EyeColor> <Height>5'' 6?</Height> <Weight>120</Weight> </DemographicDetail> <License> <LicenseNumber>ST-0000-000000</LicenseNumber> </License> </SubjectIdentification> <CaseFileDate> <AnyDate>2005-01-31</AnyDate> </CaseFileDate> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> </CriminalCase> <CriminalCase> <AgencyReference type="Case"> <IdValue>11</IdValue> </AgencyReference> <CourtName>Court Name</CourtName> <SubjectConfirmation> <ConfirmByProvidedName>true</ConfirmByProvidedName> <ConfirmByDateOfBirth>true</ConfirmByDateOfBirth> <ConfirmByGovernmentId>false</ConfirmByGovernmentId> <ConfirmBySex>false</ConfirmBySex> <ConfirmByRace>false</ConfirmByRace> </SubjectConfirmation> <SubjectIdentification> <PersonName type="Subject"> <FormattedName>Jane H. Doe</FormattedName> </PersonName> <PersonName type="Alias"> <FormattedName/> </PersonName> <PostalAddress> <DeliveryAddress> <AddressLine/> </DeliveryAddress> </PostalAddress> <DemographicDetail> <GovernmentId issuingAuthority="SSN" countryCode="US">444-33-2222</GovernmentId> <DateOfBirth>1962-03-17</DateOfBirth> <Race>White</Race> <GenderCode>2</GenderCode> <HairColor>Brown</HairColor> <EyeColor>Blue</EyeColor> <Height>5'' 6?</Height> <Weight>120</Weight> </DemographicDetail> <License> <LicenseNumber>ST-0000-000000</LicenseNumber> </License> </SubjectIdentification> <CaseFileDate> <AnyDate>2005-01-31</AnyDate> </CaseFileDate> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>civilinFraction</ChargeTypeClassification> <OffenseDate> <AnyDate>2005-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2005-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> </CriminalCase> <CriminalCase> <AgencyReference type="Case"> <IdValue>12</IdValue> </AgencyReference> <CourtName>Court Name</CourtName> <SubjectConfirmation> <ConfirmByProvidedName>true</ConfirmByProvidedName> <ConfirmByDateOfBirth>true</ConfirmByDateOfBirth> <ConfirmByGovernmentId>false</ConfirmByGovernmentId> <ConfirmBySex>false</ConfirmBySex> <ConfirmByRace>false</ConfirmByRace> </SubjectConfirmation> <SubjectIdentification> <PersonName type="Subject"> <FormattedName>Jane H. Doe</FormattedName> </PersonName> <PersonName type="Alias"> <FormattedName/> </PersonName> <PostalAddress> <DeliveryAddress> <AddressLine/> </DeliveryAddress> </PostalAddress> <DemographicDetail> <GovernmentId issuingAuthority="SSN" countryCode="US">444-33-2222</GovernmentId> <DateOfBirth>1962-03-17</DateOfBirth> <Race>White</Race> <GenderCode>2</GenderCode> <HairColor>Brown</HairColor> <EyeColor>Blue</EyeColor> <Height>5'' 6?</Height> <Weight>120</Weight> </DemographicDetail> <License> <LicenseNumber>ST-0000-000000</LicenseNumber> </License> </SubjectIdentification> <CaseFileDate> <AnyDate>2005-01-31</AnyDate> </CaseFileDate> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>civilinFraction</ChargeTypeClassification> <OffenseDate> <AnyDate>2005-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2005-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>MISDEMEANOR</ChargeTypeClassification> <OffenseDate> <AnyDate>2022-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2022-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> </CriminalCase> <CriminalCase> <AgencyReference type="Case"> <IdValue>13</IdValue> </AgencyReference> <CourtName>Court Name</CourtName> <SubjectConfirmation> <ConfirmByProvidedName>true</ConfirmByProvidedName> <ConfirmByDateOfBirth>true</ConfirmByDateOfBirth> <ConfirmByGovernmentId>false</ConfirmByGovernmentId> <ConfirmBySex>false</ConfirmBySex> <ConfirmByRace>false</ConfirmByRace> </SubjectConfirmation> <SubjectIdentification> <PersonName type="Subject"> <FormattedName>Jane H. Doe</FormattedName> </PersonName> <PersonName type="Alias"> <FormattedName/> </PersonName> <PostalAddress> <DeliveryAddress> <AddressLine/> </DeliveryAddress> </PostalAddress> <DemographicDetail> <GovernmentId issuingAuthority="SSN" countryCode="US">444-33-2222</GovernmentId> <DateOfBirth>1962-03-17</DateOfBirth> <Race>White</Race> <GenderCode>2</GenderCode> <HairColor>Brown</HairColor> <EyeColor>Blue</EyeColor> <Height>5'' 6?</Height> <Weight>120</Weight> </DemographicDetail> <License> <LicenseNumber>ST-0000-000000</LicenseNumber> </License> </SubjectIdentification> <CaseFileDate> <AnyDate>2005-01-31</AnyDate> </CaseFileDate> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>civilinFraction</ChargeTypeClassification> <OffenseDate> <AnyDate>2005-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2005-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>civilinFraction</ChargeTypeClassification> <OffenseDate> <AnyDate>2005-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Gui</Disposition> <DispositionDate> <AnyDate>2005-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> <Charge> <ChargeOrComplaint>11-22.A Joy Riding</ChargeOrComplaint> <ChargeTypeClassification>civilinFraction</ChargeTypeClassification> <OffenseDate> <AnyDate>2005-01-22</AnyDate> </OffenseDate> <Sentence>Fined $200 and 30 Days</Sentence> <Disposition>Guilty</Disposition> <DispositionDate> <AnyDate>2005-02-23</AnyDate> </DispositionDate> <Comments>Comments go here</Comments> </Charge> </CriminalCase> <RuleEngine> <RuleBase version="1.0">FranklinCountyOH.drl</RuleBase> <FindingSummary matchFound="true">At least one record unable to be eliminated.</FindingSummary> </RuleEngine> </CriminalReport> </Screening> </Screenings> </BackgroundReportPackage> </BackgroundReports>', -- enter here required XML what you want to use psResponseType => 'EXTERNAL', psResponseFormat => 'FETCH AGENT' ); commit; end;