Iron Speed Designer supports these Oracle data types:
|
Field Type |
Caveats |
|
BFILE |
|
|
BLOB |
|
|
CHAR |
|
|
CLOB |
|
|
DATE |
|
|
DOUBLE |
|
|
FLOAT |
|
|
NUMBER |
|
|
INTERVAL DAY TO SECOND |
|
|
INTERVAL YEAR TO MONTH |
|
|
LONG RAW |
|
|
LONG |
|
|
NCHAR |
|
|
NCLOB |
|
|
NUMBER |
|
|
NVARCHAR |
|
|
NVARCHAR2 |
|
|
RAW |
|
|
ROWID |
|
|
TIMESTAMP |
|
|
TIMESTAMP WITH LOCAL TIME ZONE |
|
|
TIMESTAMP WITH TIME ZONE |
|
|
UROWID |
|
|
VARCHAR |
|
|
VARCHAR2 |
|
|
XMLTYPE |
Not supported |
|
User defined types |
Not supported |
|
Nested tables |
Not supported. (Tables that are stored within the structure of other tables.) |
When running an application that uses stored procedures in an Oracle 9i database, binary data stored in fields of type RAW or LONG RAW may not be read correctly. The application may receive data truncation errors from the underlying .NET data provider in the System.Data.OracleClient namespace. This may result in "no data" being displayed on web pages.