|
MDi JLib 1.7.4 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface OracleStoredProcedureInterface
Interface for implementing a Oracle Stored Procedure class which encapsulates connections, procedure,
parameters and results. See the implementation class documentation
for usage instructions.
Method Summary | |
---|---|
boolean |
addArg(int pos,
int type,
int dir,
Object val)
Add an argument to the this object. |
String |
argsToString(int callType)
Convert the arguments to a String. |
boolean |
clearArg(int pos)
Remove a single argument from the this object. |
boolean |
clearArgs()
Remove all arguments from the this object. |
Object |
doFunction(Connection conn,
String procedure)
Executes a stored function. |
boolean |
doProcedure(Connection conn,
String procedure)
Executes a stored procedure. |
List |
getArg(int pos)
Get a single argument from this object. |
Object |
getArgVal(int pos)
Get a single arguments value. |
boolean |
setArgVal(int pos,
Object val)
Set an arguments value |
boolean |
setOutValues(CallableStatement s)
Establish the outbound parameters |
boolean |
setParameter(CallableStatement s,
int pos)
Establish the argument as a parameter. |
Method Detail |
---|
Object doFunction(Connection conn, String procedure) throws SQLException
conn
- established connection object from a JDBC connectionprocedure
- name of the function to execute
SQLException
- thrown if the function cannot be executeddoProcedure(Connection,String)
,
Connector
,
ConnectionPool
boolean doProcedure(Connection conn, String procedure) throws SQLException
conn
- established connection object from a JDBC connectionprocedure
- name of the procedure to execute
SQLException
- thrown if the procedure cannot be executeddoFunction(Connection,String)
,
Connector
,
ConnectionPool
boolean addArg(int pos, int type, int dir, Object val)
pos
- position in the procedures argument listdir
- argument direction in IN, OUT, or INOUTval
- the value of an IN or INOUT parameterboolean clearArgs()
boolean clearArg(int pos)
pos
- index of the element to remove
List getArg(int pos)
pos
- the index of the argument to return
Object getArgVal(int pos)
pos
- the index of the argument to return
boolean setParameter(CallableStatement s, int pos)
s
- CallableStatement to setpos
- argument index to set
String argsToString(int callType)
callType
- a constant call type
boolean setOutValues(CallableStatement s)
s
- CallableStatement to set
boolean setArgVal(int pos, Object val)
pos
- index of the argument to setval
- value of the argument
|
MDi JLib 1.7.4 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |