borland Packages Class Hierarchy dx.sql.dataset Package
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
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.