This method executes a command using the XmlCommandType and CommandText properties and returns the result as an XML document in a new Stream object.


// C#
public Stream ExecuteStream();

Return Value

A Stream.


The behavior of ExecuteStream varies depending on the XmlCommandType property value:

  • XmlCommandType = OracleXmlCommandType.None

    ExecuteStream throws an InvalidOperationException.

  • XmlCommandType = OracleXmlCommandType.Query

    ExecuteStream executes the select statement in the CommandText property, and if successful, returns an OracleClob object containing the XML document that was generated. OracleClob contains Unicode characters.

    If the SQL query does not return any rows, then ExcecuteStream returns an OracleClob object containing an empty XML document.

  • XmlCommandType = OracleXmlCommandType.Insert, OracleXmlCommandType.Update, or OracleXmlCommandType.Delete.

    The value of the CommandText property is an XML document. ExecuteStream saves the data in that XML document to the table or view that is specified in the XmlSaveProperties property and an empty OracleClob is returned.