Database Field Support in Oracle

Iron Speed Designer supports these Oracle data types:

Field Type

Caveats

BFILE

 

BINARY_DOUBLE
BINARY_FLOAT

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.

See Also

Oracle Database Support