public class Procedure
extends java.lang.Object
Constructor and Description |
---|
Procedure(PyCursor cursor,
PyObject name)
Constructor Procedure
|
Modifier and Type | Method and Description |
---|---|
boolean |
isInput(int index)
This method determines whether the param at the specified index is an
IN or INOUT param for a stored procedure.
|
void |
normalizeInput(PyObject params,
PyObject bindings)
Prepare the binding dictionary with the correct datatypes.
|
java.sql.CallableStatement |
prepareCall()
Prepares the statement and registers the OUT/INOUT parameters (if any).
|
java.sql.CallableStatement |
prepareCall(PyObject rsType,
PyObject rsConcur)
Prepares the statement and registers the OUT/INOUT parameters (if any).
|
java.lang.String |
toSql()
Returns the call in the syntax: {@literal
{?
|
public java.sql.CallableStatement prepareCall() throws java.sql.SQLException
java.sql.SQLException
public java.sql.CallableStatement prepareCall(PyObject rsType, PyObject rsConcur) throws java.sql.SQLException
rsType
- the value of to be created ResultSet typersConcur
- the value of the to be created ResultSet concurrencyjava.sql.SQLException
public void normalizeInput(PyObject params, PyObject bindings) throws java.sql.SQLException
params
- a non-None list of paramsbindings
- a dictionary of bindingsjava.sql.SQLException
public boolean isInput(int index) throws java.sql.SQLException
index
- JDBC indexed column index (1, 2, ...)java.sql.SQLException
public java.lang.String toSql() throws java.sql.SQLException
{? = call <procedure-name>(?, ?, ...)} {call <procedure-name>(?, ?, ...)}As of now, all parameters variables are created and no support for named variable calling is supported.
java.sql.SQLException