Mapping between Event Stream Processor datatypes and Oracle 11g datatypes.
| Event Stream Processor Datatype | Oracle Datatype |
|---|---|
| integer | int |
| long | number(19) |
| float | float |
| date | date |
| string | varchar2(n) |
| money | number(19,4) |
| timestamp | timestamp |
| boolean | smallint or bit (Does not support null values) |
| money1 | number(19,1) |
| money2 | number(19,2) |
| money3 | number(19,3) |
| money4 | number(19,4) |
| money5 | number(19,5) |
| money6 | number(19,6) |
| money7 | number(19,7) |
| money8 | number(19,8) |
| money9 | number(19,9) |
| money10 | number(19,10) |
| money11 | number(19,11) |
| money12 | number(19,12) |
| money13 | number(19,13) |
| money14 | number(19,14) |
| money15 | number(19,15) |
| interval | number(19) |
| bigdatetime | timestamp |
| binary | blob |