com.syncsoft.plainsql
Class PlainProc

java.lang.Object
  com.syncsoft.plainsql.PlainSql
      com.syncsoft.plainsql.PlainProc

public class PlainProc
extends PlainSql

Class to represent a stored procedure. Allows for multiple result sets and other stored procedure specific capabilities.

Constructor Summary

PlainProc(PSconnection conn, java.lang.String procName)
Create an object for a stored procedure call

Method Summary

ProcedureResult	executeProc(java.lang.Object... args) Execute the procedure and retrieve result sets and OUT parameters
java.sql.CallableStatement	getCallableStatement() Access the JDBC Callable statement correspondint to this statement object
boolean	getMoreResults() Move to the next result set returned by this stored procedure
java.lang.Object	getOutParm(int parm_no) Get the value of the specified OUT parameter
java.sql.ParameterMetaData	getProcParmMetaData()
java.sql.CallableStatement	getProcStatement()

Methods inherited from class com.syncsoft.plainsql.PlainSql

bindArgs, close, colcount, execute, execute, executeBatch, executeUpdate, executeUpdate, fetchAll, fetchOne, getColNames, getFetchahead, getJdbcConnection, getJdbcStatement, getPsConnection, getResult, getRsMetaData, getSql, makeRow, nextRow, setFetchAhead

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PlainProc

public PlainProc(PSconnection conn,
                 java.lang.String procName)
          throws java.sql.SQLException

Create an object for a stored procedure call

Parameters:

conn - connection

procName - , name of the procedure

Throws:

java.sql.SQLException

Method Detail

executeProc

public ProcedureResult executeProc(java.lang.Object... args)
                            throws java.sql.SQLException

Execute the procedure and retrieve result sets and OUT parameters

Returns:

a ProcResults object containing the OUT parameter values and result sets

Throws:

java.sql.SQLException

getCallableStatement

public java.sql.CallableStatement getCallableStatement()

Access the JDBC Callable statement correspondint to this statement object

Returns:

CallableStatement object

getMoreResults

public boolean getMoreResults()
                       throws java.sql.SQLException

Move to the next result set returned by this stored procedure

Returns:

true if there are further results

Throws:

java.sql.SQLException

getOutParm

public java.lang.Object getOutParm(int parm_no)
                            throws java.sql.SQLException

Get the value of the specified OUT parameter

Parameters:

parm_no -

Returns:

Object representation of the out parameter

Throws:

java.sql.SQLException

getProcParmMetaData

public java.sql.ParameterMetaData getProcParmMetaData()

Returns:

Returns the procParmMetaData.

getProcStatement

public java.sql.CallableStatement getProcStatement()

Returns:

Returns the procStatement.