StoredProcedurePlan (Denodo Virtual DataPort 9.0.0 API)

```
public interface StoredProcedurePlan
```
This interface defines the methods used to obtain information about the execution of a stored procedure.

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`ERROR` The stored procedure execution threw an error
`static int`	`INIT` The stored procedure execution has not started yet
`static int`	`OK` The stored procedure execution has finished successfully
`static int`	`PROCESSING` The stored procedure execution is being executed at this time
`static int`	`STOPPED` The stored procedure execution has been stopped

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`Date`	`getEndTime()` Obtains the time when the procedure finished its execution.
`Throwable`	`getException()` Obtains the exception associated with the error occurred in the execution.
`int`	`getNumOfTuples()` Obtains the number of tuples returned by the procedure.
`Date`	`getResponseTime()` Obtains the time when the procedure generated its first row of results.
`Date`	`getStartTime()` Obtains the time when the procedure started its execution.
`int`	`getState()` Obtains the state of the procedure execution.
`boolean`	`isComplete()` Returns whether the procedure finished successfully its execution or not.

- Field Detail
  - OK
```
static final int OK
```
    The stored procedure execution has finished successfully
    
    See Also:
    
    Constant Field Values
  - ERROR
```
static final int ERROR
```
    The stored procedure execution threw an error
    
    See Also:
    
    Constant Field Values
  - INIT
```
static final int INIT
```
    The stored procedure execution has not started yet
    
    See Also:
    
    Constant Field Values
  - PROCESSING
```
static final int PROCESSING
```
    The stored procedure execution is being executed at this time
    
    See Also:
    
    Constant Field Values
  - STOPPED
```
static final int STOPPED
```
    The stored procedure execution has been stopped
    
    See Also:
    
    Constant Field Values
- Method Detail
  - getEndTime
```
Date getEndTime()
```
    Obtains the time when the procedure finished its execution.
    
    Returns:
    
    the time when the procedure finished its execution.
  - getNumOfTuples
```
int getNumOfTuples()
```
    Obtains the number of tuples returned by the procedure.
    
    Returns:
    
    the number of tuples returned by the procedure.
  - getResponseTime
```
Date getResponseTime()
```
    Obtains the time when the procedure generated its first row of results.
    
    Returns:
    
    the time when the procedure generated its first row of results.
  - getStartTime
```
Date getStartTime()
```
    Obtains the time when the procedure started its execution.
    
    Returns:
    
    the time when the procedure started its execution.
  - getState
```
int getState()
```
    Obtains the state of the procedure execution.
    
    Returns:
    
    an integer representing the procedure state.
  - getException
```
Throwable getException()
```
    Obtains the exception associated with the error occurred in the execution.
    
    Returns:
    
    the exception associated with the error occurred in the execution.
  - isComplete
```
boolean isComplete()
```
    Returns whether the procedure finished successfully its execution or not.
    
    Returns:
    
    true if the procedure finished successfully, false otherwise.

Interface StoredProcedurePlan

Field Summary

Method Summary

Field Detail

OK

ERROR

INIT

PROCESSING

STOPPED

Method Detail

getEndTime

getNumOfTuples

getResponseTime

getStartTime

getState

getException

isComplete