This problem somehow seems to be related to http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=002569
After adding a row via
alter table T add (C number(1) default 0 not null);
and then trying to get this as integer, I'll always get a float back. This problem does only occur running a 11g db! Using 9i or 10g it works as expected.
By locating the problem, I also tried
alter table T add (C number(1) default 0);
. Using this sql, I'll get an integer - as expected.
Also this problem seems to occur only, while adding a row to an already created and filled/ used table. While creating the table with "not NULL"-rows, I'll get an Integer.
But as you can imagine the "not Null"-option is essential for me.
So why is a here a float returned? Is it a bug in Oracle 11g or in the DOA - I think it's a bug.
Thanks in advance for any responds.
edit: Using newest DOA and Turbo Delphi 2006.