borland Packages  Class Hierarchy  dx.sql.dataset Package 

OracleProcedureProvider class

java.lang.Object
   +----com.borland.dx.dataset.Provider
           +----com.borland.dx.sql.dataset.JdbcProvider
                   +----com.borland.dx.sql.dataset.ProcedureProvider
                           +----com.borland.dx.sql.dataset.OracleProcedureProvider

About the OracleProcedureProvider class

Properties  Methods  

Implements Designable, LoadCancel, ConnectionUpdateListener, Task, Serializable, EventListener

The OracleProcedureProvider class provides data to the StorageDataSet by executing the specified stored procedure (Oracle PL-SQL) through JDBC. The OracleProcedureProvider class makes no attempt to make the StorageDataSet updatable or editable; it is the developer's responsibility to ensure this prior to the start of the resolution phase.

The procedure used for the ProcedureDataSet must have an OUT parameter of type CURSOR REF as the first parameter in the procedure specification (query string). Typically this will be a PL-SQL stored function with a return type of a CURSOR REF. Oracle JDBC drivers use an extension of jdbc for this data type. JDataStore does not have a jdbc Variant type so you cannot specify this parameter directly in a parameterRow. JDataStore does the modifications that allow the callable statement to retrieve the data for this DataSet.


OracleProcedureProvider properties

*Read-only properties **Write-only properties

Properties implemented in com.borland.dx.sql.dataset.JdbcProvider

Properties implemented in com.borland.dx.sql.dataset.ProcedureProvider

Properties implemented in java.lang.Object

OracleProcedureProvider methods

Methods implemented in com.borland.dx.dataset.Provider

Methods implemented in com.borland.dx.sql.dataset.JdbcProvider

Methods implemented in com.borland.dx.sql.dataset.ProcedureProvider

Methods implemented in java.lang.Object