Types -
java.jdbc
- Direction DIRECTION_IN | DIRECTION_OUT | DIRECTION_INOUT
-
The direction of the parameter.
IN- IN parameters are used to send values to stored proceduresOUT- OUT parameters are used to get values from stored proceduresINOUT- INOUT parameters are used to send values and get values from stored procedures
- Error DatabaseError | ApplicationError
-
Represents a database or application level error returned from JDBC client remote functions.
- Param string | int | boolean | float | decimal | byte[] | Parameter
-
The parameter passed into the operations.
- SQLType TYPE_VARCHAR | TYPE_CHAR | TYPE_LONGVARCHAR | TYPE_NCHAR | TYPE_LONGNVARCHAR | TYPE_NVARCHAR | TYPE_BIT | TYPE_BOOLEAN | TYPE_TINYINT | TYPE_SMALLINT | TYPE_INTEGER | TYPE_BIGINT | TYPE_NUMERIC | TYPE_DECIMAL | TYPE_REAL | TYPE_FLOAT | TYPE_DOUBLE | TYPE_BINARY | TYPE_BLOB | TYPE_LONGVARBINARY | TYPE_VARBINARY | TYPE_CLOB | TYPE_NCLOB | TYPE_DATE | TYPE_TIME | TYPE_DATETIME | TYPE_TIMESTAMP | TYPE_ARRAY | TYPE_STRUCT | TYPE_REFCURSOR
-
The SQL Datatype of the parameter.
VARCHAR- Small, variable-length character stringCHAR- Small, fixed-length character stringLONGVARCHAR- Large, variable-length character stringNCHAR- Small, fixed-length character string with unicode supportLONGNVARCHAR- Large, variable-length character string with Unicode supportBIT- Single bit value that can be zero or one, or nilBOOLEAN- Boolean value either True or falseTINYINT- 8-bit integer value which may be unsigned or signedSMALLINT- 16-bit signed integer value which may be unsigned or signedINTEGER- 32-bit signed integer value which may be unsigned or signedBIGINT- 64-bit signed integer value which may be unsigned or signedNUMERIC- Fixed-precision and scaled decimal valuesDECIMAL- Fixed-precision and scaled decimal valuesREAL- Single precision floating point numberFLOAT- Double precision floating point numberDOUBLE- Double precision floating point numberBINARY- Small, fixed-length binary valueBLOB- Binary Large ObjectLONGVARBINARY- Large, variable-length binary valueVARBINARY- Small, variable-length binary valueCLOB- Character Large Object.NCLOB- Character large objects in multibyte national character setDATE- Date consisting of day, month, and yearTIME- Time consisting of hours, minutes, and secondsDATETIME- Both DATE and TIME with additional a nanosecond fieldTIMESTAMP- Both DATE and TIME with additional a nanosecond fieldARRAY- Composite data value that consists of zero or more elements of a specified data typeSTRUCT- User-defined structured type, consists of one or more attributesREFCURSOR- Cursor value