Question

2
Replies
615
Views
VijayM25 Member since 2014 2 posts
HomeServe Plc
Posted: 4 years ago
Last activity: 4 years ago
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
Share this page LinkedIn