Support for Oracle data types in PEGA
What are the different oracle data types are supported by PEGA without using custom functions? Please let me know what are the OOTB supported data types?. Thanks
What are the different oracle data types are supported by PEGA without using custom functions? Please let me know what are the OOTB supported data types?. Thanks
| Oracle Data Type | Supported in PEGA? (YES/NO) | OOTB Support? (YES/NO) |
| VARCHAR2(size [BYTE | CHAR]) | YES | |
| NVARCHAR2(size) | ?? | |
| NUMBER [ (p [, s]) ] | YES | |
| FLOAT [(p)] | ?? | |
| LONG | ?? | |
| DATE | YES | |
| BINARY_FLOAT | ?? | |
| BINARY_DOUBLE | ?? | |
| TIMESTAMP [(fractional_seconds_precision)] | YES | |
| TIMESTAMP [(fractional_seconds)] WITH TIME ZONE | ?? | |
| TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE | ?? | |
| INTERVAL YEAR [(year_precision)] TO MONTH | ?? | |
| INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)] | ?? | |
| RAW(size) | ?? | |
| LONG RAW | ?? | |
| ROWID | ?? | |
| UROWID [(size)] | ?? | |
| CHAR [(size [BYTE | CHAR])] | ?? | |
| NCHAR[(size)] | ?? | |
| CLOB | ?? | |
| NCLOB | ?? | |
| BLOB | YES | |
| BFILE | ?? |
HomeServe Plc
GB
Rajiv - We are doing migration from Legacy system to PEGA. Need to understand the below data types supported in PEGA?
Datatype
NVARCHAR2(size)
FLOAT [(p)]
LONG
BINARY_FLOAT
BINARY_DOUBLE
TIMESTAMP [(fractional_seconds)] WITH TIME ZONE
TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE
INTERVAL YEAR [(year_precision)] TO MONTH
INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)]
RAW(size)
LONG RAW
ROWID
UROWID [(size)]
NCHAR[(size)]
CLOB
NCLOB
BFILE