Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird

[Alexander P. <ale...@re...>]

Nikolay Samofatov wrote:
> Alexander,
>
> Oracle is not quite easy when it comes to numeric data types. Native 
> numeric in Oracle has 38 decimal digits, and as such can not always be 
> represented as SQL_INTEGER.
> Can you take an Oracle instance, and see what is going on when using 
> Firebird ODBC driver in the way described? This way we may let the users 
> from bank's IT department use our Firebird data warehousing databases 
> from their Oracle environment.
>   
Yes,  SQL_DOUBLE is a correctly data type in a general case for numeric. 
The main question is how Oracle detects parameters type for ODBC 
functions such as SQLBindParameter, SQLBindCol...
I think it must call SQLColAttribute for this. I did not try to use 
Firebird ODBC driver in Oracle as yet.

Alexander

-- 
Alexander Potapchenko
Senior developer