Iron Speed Designer supports these Oracle data types:
Field Type |
Caveats |
BFILE |
|
BINARY_DOUBLE |
The System.Data.OracleClient namespace used by the application does not natively support these types. Iron Speed Designer maps (i.e. CAST) them to Oracle’s NUMBER data type. |
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 |
The System.Data.OracleClient namespace used by the application does not natively support XMLTYPE. Iron Speed Designer maps (i.e. CAST) it to VARCHAR2(4000). The limitation, therefore, is that the field is supported only up to 4000 characters of XML data. |
User defined types |
Not supported |
Nested tables |
Not supported. (Tables 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.