- TIBCO BusinessEvents®
- RDBMS
- Database
- sp

# Database.sp

## Description

Database stored procedure support access functions

## Functions

Name | Signature and Synopsis
--- | ---
`closeStoredProc` | `void closeStoredProc(Object handle)` Closes the stored procedure.
`executeStoredProc` | `void executeStoredProc(Object handle)` Executes the given stored procedure.
`getConceptsAtIndex` | `Concept[] 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.
`getObjectAtIndex` | `Object getObjectAtIndex(Object handle, int index)` Queries the database using supplied prepared statement.
`initStoredProc` | `Object initStoredProc (String storedProc)` Initializes the given stored procedure
`readClobContent` | `String readClobContent(Object clob)` Reads content from the specified CLOB.
`setInputParameter` | `void setInputParameter(Object handle, int index, Object value)` Sets input parameter of the stored procedure at the given index. Indices are 1-based.
`setOutputParameterType` | `void 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.