borland Packages  Class Hierarchy  sql.dataset Package  Index 

OracleProcedureProvider class

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

About the OracleProcedureProvider class

Properties  Methods  

Implements LoadCancel, ConnectionUpdateListener, Task, Serializable, EventListener

The OracleProcedureProvider 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. JBuilder does not have a jdbc Variant type so you cannot specify this parameter in a parameterRow in JBuilder directly. JBuilder 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 borland.sql.dataset.JdbcProvider

Properties implemented in borland.sql.dataset.ProcedureProvider

Properties implemented in java.lang.Object

OracleProcedureProvider methods

Methods implemented in borland.jbcl.dataset.Provider

Methods implemented in borland.sql.dataset.JdbcProvider

Methods implemented in borland.sql.dataset.ProcedureProvider

Methods implemented in java.lang.Object