QAS_QUERYSTATUS_OPER

This service operation returns current query status.

Request Message: QAS_QUERYSTATUS_REQ_MSG

Element Name Description

QueryInstanceID

Query instance ID.

Example Request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_QUERYSTATUS_REQ_MSG.VERSION_1"
xmlns:qas1="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_QUERYSTATUS_REQ.VERSION_1">
   <soapenv:Header/>
   <soapenv:Body>
      <qas:QAS_QUERYSTATUS_REQ_MSG>
         <qas:QAS_QUERYSTATUS_REQ>
            <qas1:PTQASWRK class="R">
               <qas1:QueryInstanceID>
                    64ef3e36-5cf6-11dd-a1b6-cf9c0ed84831
               </qas1:QueryInstanceID>
            </qas1:PTQASWRK>
         </qas:QAS_QUERYSTATUS_REQ>
      </qas:QAS_QUERYSTATUS_REQ_MSG>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: QAS_QUERYSTATUS_RESP_MSG

Element Name Description

Status

Returns query status. Values are:

  • idNotFound

  • running

  • killed

  • posting

  • last

  • queued

  • success

  • error

NumCols

Number of columns.

TotalRows

Total number of rows.

TotalBlocks

Always returns 0.

TotalBytes

Total number of bytes.

Example Response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <QAS_QUERYSTATUS_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/
       Tools/schemas/QAS_QUERYSTATUS_RESP_MSG.VERSION_1">
         <QAS_QUERYSTATUS_RESP>
            <PTQASSTATWRK class="R" xmlns="http://xmlns.oracle.com/
             Enterprise/Tools/schemas/QAS_QUERYSTATUS_RESP.VERSION_1">
               <Status>running</Status>
               <NumColumns>0</NumColumns>
               <TotalBlocks>0</TotalBlocks>
               <TotalBytes>0</TotalBytes>
               <TotalRows>0</TotalRows>
            </PTQASSTATWRK>
         </QAS_QUERYSTATUS_RESP>
      </QAS_QUERYSTATUS_RESP_MSG>
   </soapenv:Body>
</soapenv:Envelope>