In a lot of aspects the DBC layer conforms to the JDBC Specification. Here we try to document the differences.
JDBC specifies the procedure paramerter types in a non-continous way. This leads to a different numeric representation of this type. The Zeos Enum for this is TZProcedureColumnType.
| Type | Zeos enum | numeric representation in Zeos | numeric representation in JDBC |
|---|---|---|---|
| Unknown | pctUnknown | 0 | 0 |
| In | pctIn | 1 | 1 |
| In/Out | pctInOut | 2 | 2 |
| Out | pctOut | 3 | 4 |
| Return | pctReturn | 4 | 5 |
| Result Set | pctResultSet | 5 | 3 |