Hi, in the company where I work we use "home-made" drivers to access databases. (similar to ADO, but for windows and Linux).
Now we are creating the driver for oracle. The driver internally uses OCCI (the C++ api to access Oracle). Almost everything is working. We can already execute insert/update/deletes using parameters, we can do any select and, for the select we can easily get the column data-types.
But, for the bind variables (parameters) we simple can't get the data-type. When copying data from another table or doing "fixed" selects that's easy to solve, as we know the data type, but for dynamic selects we have problems by that.
Is there any easy way to discover the parameter datatype in OCCI?
Submit an article or tip