v1.2.2
-
Direction
DIRECTION_IN | DIRECTION_OUT | DIRECTION_INOUT
-
Deprecated
The direction of the parameter.
IN
- IN parameters are used to send values to stored procedures
OUT
- OUT parameters are used to get values from stored procedures
INOUT
- INOUT parameters are used to send values and get values from stored procedures
-
Param
string | int | boolean | float | decimal | byte[] | Parameter
-
Deprecated
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
-
Deprecated
The SQL Datatype of the parameter.
VARCHAR
- Small, variable-length character string
CHAR
- Small, fixed-length character string
LONGVARCHAR
- Large, variable-length character string
NCHAR
- Small, fixed-length character string with unicode support
LONGNVARCHAR
- Large, variable-length character string with Unicode support
BIT
- Single bit value that can be zero or one, or nil
BOOLEAN
- Boolean value either True or false
TINYINT
- 8-bit integer value which may be unsigned or signed
SMALLINT
- 16-bit signed integer value which may be unsigned or signed
INTEGER
- 32-bit signed integer value which may be unsigned or signed
BIGINT
- 64-bit signed integer value which may be unsigned or signed
NUMERIC
- Fixed-precision and scaled decimal values
DECIMAL
- Fixed-precision and scaled decimal values
REAL
- Single precision floating point number
FLOAT
- Double precision floating point number
DOUBLE
- Double precision floating point number
BINARY
- Small, fixed-length binary value
BLOB
- Binary Large Object
LONGVARBINARY
- Large, variable-length binary value
VARBINARY
- Small, variable-length binary value
CLOB
- Character Large Object.
NCLOB
- Character large objects in multibyte national character set
DATE
- Date consisting of day, month, and year
TIME
- Time consisting of hours, minutes, and seconds
DATETIME
- Both DATE and TIME with additional a nanosecond field
TIMESTAMP
- Both DATE and TIME with additional a nanosecond field
ARRAY
- Composite data value that consists of zero or more elements of a specified data type
STRUCT
- User-defined structured type, consists of one or more attributes
REFCURSOR
- Cursor value