JavaCallableStatementMBS.getBlob(parameterIndex as Integer) as JavaBlobMBS

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language.

Parameters:
i - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

• getBlob(parameterName as string) as JavaBlobMBS

JavaCallableStatementMBS.getBlob(parameterName as string) as JavaBlobMBS

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

• getBlob(parameterIndex as Integer) as JavaBlobMBS

JavaCallableStatementMBS.getBoolean(parameterIndex as Integer) as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is false.

See also:

• getBoolean(parameterName as string) as boolean

JavaCallableStatementMBS.getBoolean(parameterName as string) as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is false.

See also:

• getBoolean(parameterIndex as Integer) as boolean

JavaCallableStatementMBS.getByte(parameterIndex as Integer) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getByte(parameterName as string) as Integer

JavaCallableStatementMBS.getByte(parameterName as string) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getByte(parameterIndex as Integer) as Integer

JavaCallableStatementMBS.getClob(parameterIndex as Integer) as JavaClobMBS

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC CLOB parameter as a Clob object in the Java programming language.

Parameters:
i - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

• getClob(parameterName as string) as JavaClobMBS

JavaCallableStatementMBS.getClob(parameterName as string) as JavaClobMBS

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.

See also:

• getClob(parameterIndex as Integer) as JavaClobMBS

JavaCallableStatementMBS.getDouble(parameterIndex as Integer) as Double

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getDouble(parameterName as string) as Double

JavaCallableStatementMBS.getDouble(parameterName as string) as Double

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getDouble(parameterIndex as Integer) as Double

JavaCallableStatementMBS.getFloat(parameterIndex as Integer) as single

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getFloat(parameterName as string) as single

JavaCallableStatementMBS.getFloat(parameterName as string) as single

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getFloat(parameterIndex as Integer) as single

JavaCallableStatementMBS.getInt(parameterIndex as Integer) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getInt(parameterName as string) as Integer

JavaCallableStatementMBS.getInt(parameterName as string) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getInt(parameterIndex as Integer) as Integer

JavaCallableStatementMBS.getLong(parameterIndex as Integer) as Int64

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getLong(parameterName as string) as Int64

JavaCallableStatementMBS.getLong(parameterName as string) as Int64

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getLong(parameterIndex as Integer) as Int64

JavaCallableStatementMBS.getShort(parameterIndex as Integer) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getShort(parameterName as string) as Integer

JavaCallableStatementMBS.getShort(parameterName as string) as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.

See also:

• getShort(parameterIndex as Integer) as Integer

JavaCallableStatementMBS.getString(parameterIndex as Integer) as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.

Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is null.

See also:

• getString(parameterName as string) as String

JavaCallableStatementMBS.getString(parameterName as string) as String

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.

Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is null.

See also:

• getString(parameterIndex as Integer) as String