Return
-
Title
BINARY_FLOAT columns not displayed in Schema Browser -
Description
The Schema Browser doesn't display BINARY_FLOAT columns in a table with only this column type inside it.
The following message appears:
'The table only contains BINARY_FLOAT columns, which are not supported by your Oracle Client'This happens with 10g and 11g Oracle clients -
Resolution
WORKAROUND:
None.STATUS:
Waiting for fix in a future release of Toad for Oracle -
Defect ID
ST78722 -
Additional Information
A script to replicate this is:
CREATE TABLE AZ
(
BZ BINARY_FLOAT
)
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
insert into bz values (1.0);
commit;