Oracle Web Services On Demand Troubleshooting Guide > Error Codes: Causes and Solutions >

SBL-EAI-13005

This error code has no error symbol.

Generic Error Message

Unmatched quotes: LiteralData (SBL-EAI-13005).

Causes and Solutions

Quotation marks are missing from the query value. This error is often returned with error SBL-EAI-13002.

Error Message

Unmatched quotes: 'Customer'' (SBL-EAI-13005).

Incorrect SOAP Request

In the following incorrect SOAP request, the quotation marks in the ContactType query expression do not match because there are only three quotation marks in the expression:

<?xml version="1.0" encoding="UTF-8"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Header>

      <wsse:Security>

         <wsse:UsernameToken>

            <wsse:Username>%%%USERNAME%%%</wsse:Username>

            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">%%%PASSWORD%%%</wsse:Password>

         </wsse:UsernameToken>

      </wsse:Security>

   </soap:Header>

   <soap:Body>

      <ContactQueryPage_Input xmlns="urn:crmondemand/ws/ecbs/contact/">

         <ListOfContact pagesize="5" startrownum="0" recordcountneeded="true">

            <Contact>

               <ContactFirstName />

               <ContactType>='Customer''</ContactType>

            </Contact>

         </ListOfContact>

      </ContactQueryPage_Input>

   </soap:Body>

</soap:Envelope>

Resolving Error SBL-EAI-13005

Ensure that all query expressions in the Web service request have quotation marks that enclose literal data. Literal data must be enclosed in single quotation marks. If you want to use a single quotation mark within a literal, place another single quotation mark immediately beside that quotation mark. For more information on query syntax, see Oracle Web Services On Demand Guide.

Correcting the SOAP Request

To correct the SOAP request, the quotation marks in the ContactType query expression must match.

The query looks for ContactType = Customer" so you must add another quotation mark to the query expression:

<?xml version="1.0" encoding="UTF-8"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Header>

      <wsse:Security>

         <wsse:UsernameToken>

            <wsse:Username>%%%USERNAME%%%</wsse:Username>

            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">%%%PASSWORD%%%</wsse:Password>

         </wsse:UsernameToken>

      </wsse:Security>

   </soap:Header>

   <soap:Body>

      <ContactQueryPage_Input xmlns="urn:crmondemand/ws/ecbs/contact/">

         <ListOfContact pagesize="5" startrownum="0" recordcountneeded="true">

            <Contact>

               <ContactFirstName />

               <ContactType>='Customer'''</ContactType>

            </Contact>

         </ListOfContact>

      </ContactQueryPage_Input>

   </soap:Body>

</soap:Envelope>