ExecuteNonQuery, ExecuteReader, and ExecuteScalar Operations Message Schemas
The Microsoft BizTalk Adapter for Oracle E-Business Suite exposes the ExecuteNonQuery, ExecuteReader, and ExecuteScalar outbound operations at the root level to execute any arbitrary SQL statements or PL/SQL blocks in Oracle E-Business Suite.
For more information about:
These operations, see Support for ExecuteNonQuery, ExecuteReader, and ExecuteScalar Operations.
Performing these operations using the Oracle E-Business adapter, see ExecuteReader, ExecuteScalar, or ExecuteNonQuery Operations in SQL using BizTalk Server.
Message Structure for the ExecuteNonQuery, ExecuteReader, and ExecuteScalar Operations
The messages in these operations follow a request-response message exchange pattern, and the following table shows the structure of these request and response messages.
Note
See entity descriptions after the table.
| Operation | XML Message |
|---|---|
| ExecuteNonQuery Request | <?xml version="1.0" encoding="utf-8" ?> <ExecuteNonQuery xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/GenericOperation/ "> <Query>[PL/SQL block]</Query> <OutputRefCursorNames> <string>[stringvalue1]</string> <string>[stringvalue2]</string> … </OutputRefCursorNames> </ExecuteNonQuery> |
| ExecuteNonQuery Response | <?xml version="1.0" encoding="utf-8" ?> <ExecuteNonQueryResponse xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/GenericOperation/ "> <ExecuteNonQueryResult>[value]</ExecuteNonQueryResult> <OutputRefCursors> <DataSet> <Any>[value]</Any> <Any>[value]</Any> … </DataSet> </OutputRefCursors> </ExecuteNonQueryResponse> |
| ExecuteReader Request | <?xml version="1.0" encoding="utf-8" ?> <ExecuteReader xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/GenericOperation/ "> <Query>[PL/SQL block]</Query> </ExecuteReader> |
| ExecuteReader Response | <?xml version="1.0" encoding="utf-8" ?> <ExecuteReaderResponse xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/GenericOperation/ "> <ExecuteReaderResult> <Any>[value]</Any> <Any>[value]</Any> … </ExecuteReaderResult> </ExecuteReaderResponse> |
| ExecuteScalar Request | <?xml version="1.0" encoding="utf-8" ?> <ExecuteScalar xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/GenericOperation/ "> <Query>[PL/SQL block]</Query> </ExecuteScalar> |
| ExecuteScalar Response | <?xml version="1.0" encoding="utf-8" ?> <ExecuteScalarResponse xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/GenericOperation/ "> <ExecuteScalarResult>[value]</ExecuteScalarResult> </ExecuteScalarResponse> |
Entity descriptions:
[PL/SQL block] = The entire PL/SQL block to be executed.
[stringvalue1] = A value in the array of strings.
Message Action for the ExecuteNonQuery, ExecuteReader, and ExecuteScalar Operations
The following table shows the message actions that are used by the ExecuteNonQuery, ExecuteReader, and ExecuteScalar operations.
| Operation | Action |
|---|---|
| ExecuteNonQuery Request | GenericOp/ExecuteNonQuery |
| ExecuteNonQuery Response | GenericOp/ExecuteNonQuery/response |
| ExecuteReader Request | GenericOp/ExecuteReader |
| ExecuteReader Response | GenericOp/ExecuteReader/response |
| ExecuteScalar Request | GenericOp/ExecuteScalar |
| ExecuteScalar Response | GenericOp/ExecuteScalar/response |