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.
- 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