dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleScript Class / ExecuteNext Method / ExecuteNext(OracleDataReader) Method
An OracleDataReader to store result set.

In This Topic
ExecuteNext(OracleDataReader) Method
In This Topic
Executes the next statement from the script.
Syntax
'Declaration
 
Public Overloads Function ExecuteNext( _
   ByRef reader As OracleDataReader _
) As Boolean
 

Parameters

reader
An OracleDataReader to store result set.

Return Value

true if there are more statements to execute; otherwise, false.
Remarks

Use the ExecuteNext(OracleDataReader) method to execute the statements from the script one by one. Text of the script should be specified by ScriptText property.

After the method has executed, the Devart.Common.DbScript.Progress event fires, where you can obtain statement text and process query results. If the statement has produced an error, event Devart.Common.DbScript.Error fires.

To restart execution from the beginning of the script call Devart.Common.DbScript.Reset method. When ScriptText property is modified, OracleScript automatically positions on the first statement.

See Also