Database.sp

Description

Database stored procedure support access functions

Functions

NameSignature and Synopsis
closeStoredProcvoid closeStoredProc(Object handle)
Closes the stored procedure.
executeStoredProcvoid executeStoredProc(Object handle)
Executes the given stored procedure.
getConceptsAtIndexConcept[] getConceptsAtIndex(Object handle, int index, String conceptURI)
This function is to be used where the output at the given index is a database cursor and where the contents of the underlying cursor can be mapped to a db concept.
getObjectAtIndexObject getObjectAtIndex(Object handle, int index)
Queries the database using supplied prepared statement.
initStoredProcObject initStoredProc (String storedProc)
Initializes the given stored procedure
readClobContentString readClobContent(Object clob)
Reads content from the specified CLOB.
setInputParametervoid setInputParameter(Object handle, int index, Object value)
Sets input parameter of the stored procedure at the given index. Indices are 1-based.
setOutputParameterTypevoid setOutputParameterType(Object handle, int index, int beType)
For stored procedure with $1out$1 parameters, sets the sqltype of the return type at the given index.