Question

2
Replies
628
Views
Close popover
Vijay Madana (VijayM25)
HomeServe Plc

HomeServe Plc
GB
VijayM25 Member since 2014 2 posts
HomeServe Plc
Posted: October 19, 2016
Last activity: October 20, 2016
Closed

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

Oracle Data TypeSupported in PEGA? (YES/NO)OOTB Support? (YES/NO)
VARCHAR2(size [BYTE | CHAR])YES 
NVARCHAR2(size)?? 
NUMBER [ (p [, s]) ]YES 
FLOAT [(p)]?? 
LONG?? 
DATEYES 
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?? 
BLOBYES 
BFILE?? 
Data Integration
Moderation Team has archived post