Menu

DBC-Layer: Differences between JDBC and DBC Log in to Edit

marsupilami79

About

In a lot of aspects the DBC layer conforms to the JDBC Specification. Here we try to document the differences.

GetProcedureColumns

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