QAS_EXECUTEQRYPOLL_REST_POST

This service operation is similar to QAS_EXECUTEQRYPOLL_REST_GET.v1, but is used for running an ad-hoc query request in the Process Scheduler. This service operation should be used for long running queries or queries with large result sets. The query is executed in batch mode through Integration Broker asynchronous servers (Pub/Sub) and the Process Schedulers.

Example Request:

http://<servername>:<port>/PSIGW/RESTListeningConnector/<defaultlocal node>/ExecuteAdhocQueryPoll.v1/executeadhocquerypoll

POST Message

<?xml version="1.0"?>
<QAS_EXEQRY_SYNC_REQ_MSG>
 	<QAS_EXEQRY_SYNC_REQ>
		<QueryName/>
		<isConnectedQuery>N</isConnectedQuery>
 		<XMLString>
		<!--1 or more repetitions:-->
	<RECORD>
		<RCDNUM>1</RCDNUM>
 		<RCDNAME>PSMSGSETDEFN</RCDNAME>
		<CORRNAME>A</CORRNAME>
		<JOINTYPE></JOINTYPE>
		<JOINRCDALIAS></JOINRCDALIAS>
		<JOINFIELD></JOINFIELD>
  		<RCDSELECTNUM>1</RCDSELECTNUM>
	</RECORD>
	<!--1 or more repetitions:-->
	<FIELD>
		<FIELDNUM>1</FIELDNUM>
 		<FIELDNAME>MESSAGE_set_nbr</FIELDNAME>
 		<FIELDRCDNUM>1</FIELDRCDNUM>
	 	<DESCR></DESCR>
		<AGGREGATE_TYPE>None</AGGREGATE_TYPE>
		<HEADING_TYPE>RFT Short</HEADING_TYPE>
 		<HEADING></HEADING>
		<COLUMNNUM>1</COLUMNNUM>
		<ORDERBYNUM>1</ORDERBYNUM>
		<ORDERBYDIR></ORDERBYDIR>
		<FIELDSELECTNUM>1</FIELDSELECTNUM>
		<EXPRESSION_AS_FIELD></EXPRESSION_AS_FIELD>
	</FIELD>
 	<FIELD>
		<FIELDNUM>2</FIELDNUM>
		<FIELDNAME>descr</FIELDNAME>
		<FIELDRCDNUM>1</FIELDRCDNUM>
		<DESCR></DESCR>
		<AGGREGATE_TYPE>None</AGGREGATE_TYPE>
		<HEADING_TYPE>RFT Short</HEADING_TYPE>
 		<HEADING></HEADING>
		<COLUMNNUM>2</COLUMNNUM>
		<ORDERBYNUM>0</ORDERBYNUM>
		<ORDERBYDIR></ORDERBYDIR>
		<FIELDSELECTNUM>1</FIELDSELECTNUM>
		<EXPRESSION_AS_FIELD></EXPRESSION_AS_FIELD>
	</FIELD>
 	<SELECT>
		<SELECTNUM>1</SELECTNUM>
		<PARENTSELECTNUM>0</PARENTSELECTNUM>
		<SELECTTYPE>Main</SELECTTYPE>
		<QRYDISTINCT></QRYDISTINCT>
	</SELECT>
 	</XMLString> 
 		<OwnerType/>
		<BlockSizeKB>0</BlockSizeKB>
		<MaxRow>1000</MaxRow>
		<OutResultType>XMLP</OutResultType>
		<OutResultFormat>NONFILE</OutResultFormat>
		<Prompts/>
	 </QAS_EXEQRY_SYNC_REQ>
</QAS_EXEQRY_SYNC_REQ_MSG>

Example Response:

<?xml version="1.0"?>
<QAS_EXEQRYSYNCPOLL_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/
Tools/schemas/QAS_EXEQRYSYNCPOLL_RESP_MSG.VERSION_1">
    <QAS_EXEQRYSYNCPOLL_RESP>
        <PTQASWRK class="R" xmlns="http://xmlns.oracle.com/Enterprise/
         Tools/schemas/QAS_EXEQRYSYNCPOLL_RESP.VERSION_1">
            <QueryInstance>fbf8a6f3-f1b8-11e3-b37c-9e8b0079144b</QueryInstance>
        </PTQASWRK>
    </QAS_EXEQRYSYNCPOLL_RESP>
</QAS_EXEQRYSYNCPOLL_RESP_MSG>