Platforms to show: All Mac Windows Linux Cross-Platform
JavaCallableStatementMBS class
Super class: JavaStatementMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
class | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
The interface used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters can be used for input, output or both. Parameters are referred to sequentially, by number, with the first parameter being 1.
{?= call <procedure-name>[<arg1>,<arg2>, ...]}
{call <procedure-name>[<arg1>,<arg2>, ...]}
IN parameter values are set using the set methods inherited from PreparedStatement. The type of all OUT parameters must be registered prior to executing the stored procedure; their values are retrieved after execution via the get methods provided here.
A CallableStatement can return one ResultSet object or multiple ResultSet objects. Multiple ResultSet objects are handled using operations inherited from Statement.
For maximum portability, a call's ResultSet objects and update counts should be processed prior to getting the values of output parameters.
Subclass of the JavaStatementMBS class.
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.
- 38 methods
- method Constructor Private
- method getBlob(parameterIndex as Integer) as JavaBlobMBS
- method getBlob(parameterName as string) as JavaBlobMBS
- method getBoolean(parameterIndex as Integer) as boolean
- method getBoolean(parameterName as string) as boolean
- method getByte(parameterIndex as Integer) as Integer
- method getByte(parameterName as string) as Integer
- method getClob(parameterIndex as Integer) as JavaClobMBS
- method getClob(parameterName as string) as JavaClobMBS
- method getDouble(parameterIndex as Integer) as Double
- method getDouble(parameterName as string) as Double
- method getFloat(parameterIndex as Integer) as single
- method getFloat(parameterName as string) as single
- method getInt(parameterIndex as Integer) as Integer
- method getInt(parameterName as string) as Integer
- method getLong(parameterIndex as Integer) as Int64
- method getLong(parameterName as string) as Int64
- method getShort(parameterIndex as Integer) as Integer
- method getShort(parameterName as string) as Integer
- method getString(parameterIndex as Integer) as String
- method getString(parameterName as string) as String
- method registerOutParameter(parameterIndex as Integer, sqlType as Integer)
- method registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
- method registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
- method registerOutParameter(parameterName as string, sqlType as Integer)
- method registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
- method registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
- method setBoolean(parameterName as string, x as boolean)
- method setByte(parameterName as string, x as Integer)
- method setDouble(parameterName as string, x as Double)
- method setFloat(parameterName as string, x as single)
- method setInt(parameterName as string, x as Integer)
- method setLong(parameterName as string, x as int64)
- method setNull(parameterName as string, sqlType as Integer)
- method setNull(parameterName as string, sqlType as Integer, typeName as string)
- method setShort(parameterName as string, x as Integer)
- method setString(parameterName as string, x as string)
- method wasNull as boolean
Super class JavaStatementMBS
- 6 properties
- property EscapeProcessing as boolean
- property FetchDirection as Integer
- property FetchSize as Integer
- property MaxFieldSize as Integer
- property MaxRows as Integer
- property QueryTimeout as Integer
- 28 methods
- method addBatch(sql as string)
- method cancel
- method clearBatch
- method clearWarnings
- method close
- method CLOSE_ALL_RESULTS as Integer
- method CLOSE_CURRENT_RESULT as Integer
- method Constructor Private
- method execute(sql as string) as boolean
- method execute(sql as string, autoGeneratedKeys as Integer) as boolean
- method executeBatch as Integer()
- method executeQuery(sql as string) as JavaResultSetMBS
- method executeUpdate(Sql as string) as Integer
- method executeUpdate(Sql as string, autoGeneratedKeys as Integer) as Integer
- method EXECUTE_FAILED as Integer
- method getGeneratedKeys as JavaResultSetMBS
- method getMoreResults as boolean
- method getMoreResults(current as Integer) as boolean
- method getResultSet as JavaResultSetMBS
- method getResultSetConcurrency as Integer
- method getResultSetHoldability as Integer
- method getResultSetType as Integer
- method getUpdateCount as Integer
- method KEEP_CURRENT_RESULT as Integer
- method NO_GENERATED_KEYS as Integer
- method RETURN_GENERATED_KEYS as Integer
- method setCursorName(name as string)
- method SUCCESS_NO_INFO as Integer
Super class JavaObjectMBS
- 16 properties
- property ClassName as String
- property Database as Variant
- property Handle as Integer
- property Lasterror as Integer
- property Tag as Variant
- property VM as JavaVMMBS
- property BooleanField(TheField as JavaFieldMBS) as boolean
- property ByteField(TheField as JavaFieldMBS) as Integer
- property CharField(TheField as JavaFieldMBS) as Integer
- property DoubleField(TheField as JavaFieldMBS) as Double
- property Field(TheField as JavaFieldMBS) as Variant
- property FloatField(TheField as JavaFieldMBS) as single
- property IntField(TheField as JavaFieldMBS) as Integer
- property LongField(TheField as JavaFieldMBS) as Int64
- property ObjectField(TheField as JavaFieldMBS) as JavaObjectMBS
- property ShortField(TheField as JavaFieldMBS) as Integer
- 28 methods
- method CallBooleanMethod(MethodID as JavaMethodMBS, args as memoryblock) as boolean
- method CallByteMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallCharMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallDoubleMethod(MethodID as JavaMethodMBS, args as memoryblock) as Double
- method CallFloatMethod(MethodID as JavaMethodMBS, args as memoryblock) as single
- method CallIntMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallLongMethod(MethodID as JavaMethodMBS, args as memoryblock) as Int64
- method CallMethod(MethodID as JavaMethodMBS, args() as Variant) as Variant
- method CallNonvirtualBooleanMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as boolean
- method CallNonvirtualByteMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualCharMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualDoubleMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Double
- method CallNonvirtualFloatMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as single
- method CallNonvirtualIntMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualLongMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Int64
- method CallNonvirtualMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args() as Variant) as Variant
- method CallNonvirtualObjectMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as JavaObjectMBS
- method CallNonvirtualShortMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualVoidMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock)
- method CallObjectMethod(MethodID as JavaMethodMBS, args as memoryblock) as JavaObjectMBS
- method CallShortMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallVoidMethod(MethodID as JavaMethodMBS, args as memoryblock)
- method Constructor Private
- method GetDirectBufferAddress(directbuffer as JavaObjectMBS) as Integer
- method GetDirectBufferCapacity(directbuffer as JavaObjectMBS) as Integer
- method IsInstanceOf(TheClass as JavaClassMBS) as boolean
- method IsSameObject(obj as JavaObjectMBS) as boolean
- method ObjectClass as JavaClassMBS
This class has no sub classes.
Some methods using this class:
- JavaConnectionMBS.prepareCall(sql as string) as JavaCallableStatementMBS
- JavaConnectionMBS.prepareCall(sql as string, resultSetType as Integer, resultSetConcurrency as Integer) as JavaCallableStatementMBS
- JavaConnectionMBS.prepareCall(sql as string, resultSetType as Integer, resultSetConcurrency as Integer, resultSetHoldability as Integer) as JavaCallableStatementMBS
The items on this page are in the following plugins: MBS Java Plugin.
JavaByteArrayMBS - JavaCharArrayMBS